Hi there i have strange thing , my clients emploee sometimes puts double ' instead of " into contractors name .
if i use insert TSQL ie:
INSERT INTO [AA].[AA].[RA] ([concode]) VALUES ('''TK-BUD' )
then in the end in DB in concod field, there is only 'TK-BUD instead of ''TK-BUD . Now i cant compare it to data which is inserted via some soft (which can somehow insert '' correctly ) . So the question is what i have to do to insert '' correctly into DB.
declare @xxx as varchar(50)
INSERT INTO [AA].[AA].[RA] ([concode]) VALUES (@xxx)
also do not help .