tshaikh
asked on
How to protect a forward slash in a sql string
I need to retrieve records with the / from a table. However, I am using a stored procedure with string variable
'Select * from table a where code in ('/')' <=== all single quotes and I do not return any rows. Please advice. I've tried code in (''//'').
Thanks
'Select * from table a where code in ('/')' <=== all single quotes and I do not return any rows. Please advice. I've tried code in (''//'').
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or:
SELECT *
FROM a
WHERE (code LIKE '%' + CHAR(47) + '%')
whatever u need
SELECT *
FROM a
WHERE (code LIKE '%' + CHAR(47) + '%')
whatever u need
I think what you want is
SELECT *
FROM a
WHERE code Like '%/%'
This will return all records where the field [code] contains the character '/' even if it's the only character in the field.
Hammadian2's suggestion above will only return those records where '/' is all that appears in the field [code].
SELECT *
FROM a
WHERE code Like '%/%'
This will return all records where the field [code] contains the character '/' even if it's the only character in the field.
Hammadian2's suggestion above will only return those records where '/' is all that appears in the field [code].
(Hammadian2 types faster than I do.)
ASKER
Thank you both for such a quick reply. I used char(47).
ASKER
Thanks