ivan_sleeps
May 18th, 2006, 10:24 PM
I am using sql server 2005 and need pass a company name into a procedure to determine if that name contains an accented character.
In oracle I would use:
IF CONVERT(v_name_test,'US7ASCII', 'WE8ISO8859P1') <> v_name_test THEN....
How would I do it in sql server 2005?
Thanks in advanced,
Ivan
In oracle I would use:
IF CONVERT(v_name_test,'US7ASCII', 'WE8ISO8859P1') <> v_name_test THEN....
How would I do it in sql server 2005?
Thanks in advanced,
Ivan