Question on INSERT VALUES

[NavMen]

Hi All,

I'm trying to put this String: CONTAINS('""*aco"" NEAR ""*EVIN""')[/color red] into a table.

Using: Insert Into POL_POLICY(POL_QUERY) Values ('CONTAINS ('""*aco"" NEAR ""KEVIN""') ')

Doesn't work, what must I do to get it right....!!

Maybe it is easy but I don't see it anymore :-(

Thanks,

Navmen

 

[gmmastros]

You need to double the single-quotes.

 Insert Into POL_POLICY(POL_QUERY) Values ('CONTAINS ([!]''[/!]""*aco"" NEAR ""KEVIN""[!]''[/!]) ')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[NavMen]

Thanks George,

That works!!

/Navmen