Viewing 4 posts - 1 through 4 (of 4 total)
have you tried
REPLACE(PRODUCTDESC,nchar(8482),'')
There is NO representation for Trademark in the 850 character set
Your field MUST be defined as nvarchar before you load the data into the table
May 5, 2016 at 12:06 pm
Hi,
You must be set to code page 850 to get the Microsoft T - works fine on code page 1252
May 3, 2016 at 2:27 pm
sorry, should have given you more than that...
declare @rc int
EXEC master..xp_fileexist 'c:\file.txt', @rc OUTPUT
--PRINT 'EXECUTE FILE EXIST - RCODE: ' + CAST(@RC AS VARCHAR(12)) -- FOR TESTING...
June 5, 2007 at 10:50 am
Have you tried
EXEC master..xp_fileexist 'c:\file.txt'
June 5, 2007 at 10:46 am
Viewing 4 posts - 1 through 4 (of 4 total)