Escape sequence in Transact-SQL-Eurgent 1

[raminriahi]

I'm trying to utilize sql statement in an EDI application, but i have problem with handling some special characters:
Single quote '
Double Quote "
Question mark ?

I was wonder if i can use escape sequence notation for them.
(as far as i know ,in java or VB let's say, it's \nnn . is there any similar concept in sql?

* please help ASAP - it's crirical to me !

Thanks in advance,

Ramin

 

[MacLeod72]

If they are within a SQL Server string literal, you can use the CHAR function:

' ==> CHAR(39)
" ==> CHAR(34)
? ==> CHAR(63)

Example: It's a lovely day ==> 
'It' + CHAR(39) + 's a lovely day'

If your issue is within the SQL command outside of a string literal, you'll need to refer to the language documentation for specific escape characters. Is this a compile error or run-time?

Hope this helps!
--Rob

 

[SQLBill]

There are escape characters in TSQL, refer to the BOL and look up ESCAPE for more information, but basically it's:


WHERE mycolumn LIKE '5/%' ESCAPE '/'

That makes the % be percent vice a wildcard.

-SQLBill