Wild Character

UDA

Wild Character



I am doing an insert into a coulmn with the data 'N0 d'acchs commercial'

but it errors out since there is a single quote before the data finishes.

Please let me know which wild character should be used so that it accepts it as a quote inside the text
3 REPLIES

Re: Wild Character

use another simple quote, i.e. SEL '''' AS simple_quote
returns one simple quote char

Re: Wild Character

Hi Keerthan,
Once I faces similar challenge,
We can insert such special char using Bteq
1st load the data into a .txt file and try to insert using Bteq script
this will help

Re: Wild Character

This should work:

select 'N0 d''acchs commercial';

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

'N0 d''acchs commercial'
------------------------
N0 d'acchs commercial