Does anyone know how to change quot

[nuct]

Does anyone know how to change quotation mark: '

into something else so I can wrap strings with something else because i need to wrap a string that ends with a quotation mark.

e.g.

SELECT 'string 'string in quotes'' || FIELD

I hope this maked sense, is there an environment variable for this?

Thanks,

Simon

 

[tlbroadbent]

Just use two single quotes on the enclosed string.

SELECT 'string ''string in quotes''' Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[nuct]

Cheers 4 that

Simon.