special characters
-
My problem:
I need create result with special characters example:
in table is Peter
I need in result
'Peter'
Thanx
M.
-
If the table is called bar and the column where Peter is stored is called foo, then this would give the result you want:
SELECT '' + foo + '' AS foo
FROM bar
-
Also if you know the ASCII code of your special character then you can insert it like this example is inserting a carriage return (ASCII code 13) between Column1 and Column2 concatenated a a single string
select Column1+ char(13) + Column2 from MyTable
And a a correction to Chris's example he is missing some quotes
The correct answer is:
SELECT '''' + foo + '''' AS foo
FROM bar
Bye
Gabor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply