Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Text In Row values with Removing Next Line image

Author  Topic 

Kalaiselvan
Posting Yak Master

112 Posts

Posted - 2012-02-01 : 02:38:31
A text stored in MY SQL column.
If the text is copied it shows as

1=Model
2=Dealer Identification
3=Dealer code
4=Dealer name

But actual text is separated with some symbol like text and its shown in next line.
Ex: 1=Model@2=Dealer Identification@3=Dealer code@4=Dealer name@

Am just replacing that symbol into @ symbol. When i am trying to copy that symbol it goes to next line. Please help me to solve this.

Need the text into Rows like below output:
[Column]
Model
Dealer Identification
Dealer code
Dealer name

Please help me to fix that symbol like next line issue and to get the output as row values.

Regards,
Kalaiselvan R
Love Yourself First....

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-01 : 09:33:11
its a presentation issue
why cant you handle this at your front end?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -