Hi,
I have a result set like
ID-------- Post_Code----Suburb
2036-------2112----------Beverly Hills
3478-------2167----------Cremone
5390-------2022----------Paddington
How do I add quotation marks for ID and Post_Code as in
ID-------- Post_Code----Suburb
"2036"-------"2112"----------Beverly Hills
"3478"-------"2167"----------Cremone
"5390"-------"2022"----------Paddington
Can anyone please help?
Thanks
Michelle
Try this....
select
'"'+cast(ID as varchar)+'"',
'"'+cast(Post_Code as varchar)+'"',
Suburb
from
MyTable
As always, Kev has the right answer. Just for completeness, you could use the built in quotename function, specifying " as the option quote character of course. This will double up the quotation marks if one is actually located within your string though, whether or not this is a good thing depends on your situation.
http://msdn.microsoft.com/en-us/library/ms176114(SQL.90).aspx
I have got an error message 'a character string failed conversion to numeric value'. What should I do? Michelle
