Re: Converting string to IN query

[André Volpato <andre.volpato@xxxxxxxxxxxxxxxxxxxxx>]

Andrus escreveu:
> <snip>
> SELECT * FROM invoices WHERE invoiceno IN ( '1,3,4' );
>
> but this causes error.
> <snip>

change it to ( '1','3','4' ) or ( 1,3,4 )

--

ACV