how can I pass a quota and comma string in SP?

[jliang]

Hi,

I wrote a store procedure and I need pass a parameter like:

'('A,'B','C','D')' as a string to SP. Can you help me how can I work around for it?

Thanks very much

Jing

 

[CapsuleCorpJX]

Very easy:
'' = '

so for your query:
call db.SP('(''A,''B'',''C'',''D'')');

 

[jliang]

It works fine.

Thank very much!

Jing