INSERT INTO [AA].[AA].[RA]  ([concode])  VALUES  ('''TK-BUD' )

declare @xxx as varchar(50)
set @xxx='''TK-BUD'
INSERT INTO [AA].[AA].[RA]  ([concode])  VALUES  (@xxx)

INSERT INTO [AA].[AA].[RA] ([concode]) VALUES (CHAR(39) + CHAR(39) + 'TK-BUD' )

quote:

---

Originally posted by romeck

@chadmat - no that wont work, couses error

@Lamprey - :) yes thats work thanks (although i was expecting that simplier way exist couse i have to create function that have to analyse char after char in the 40 char long string which i presume is a bit not efficient , many many "if"s couse of ' could be first could be last or could be multiplied :) )

---

declare @test table
(
val varchar(30)
)

insert @test values('''''test'),(char(39) + char(39) + 'test')

select * from @test


output
----------------------------
val
------------------------------
''test
''test