mpdillon
asked on
SQL WHERE question
I need to find the records which contain some specicial characters such as a trademark. In Visual Basic (maybe unicode?) the trademark is represented by AscW(174).
How would I structure my WHERE clause to return the records that contain the trademark?
Select Field1 From TableA where Field1 Like ??????????? or Contains?
Thanks,
pat
How would I structure my WHERE clause to return the records that contain the trademark?
Select Field1 From TableA where Field1 Like ??????????? or Contains?
Thanks,
pat
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both,
I was using Chr and not Char. It now works.
I was using Chr and not Char. It now works.
Open in new window