| Subject | Re: [firebird-support] Problem in executing query using 'IN' statement. |
|---|---|
| Author | Virna Constantin |
| Post date | 2016-09-16T15:09:31Z |
On Friday, September 16, 2016 4:35 PM, "'Joje' joje@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
AND Tb3.NAME _IDS IN (CAST(Tb2.NAME_ID AS VARCHAR(250))) /*Here Tb3.NAME _IDS is varchar & Tb2.NAME _IDS is int so casted into varchar. This line gives wrong output */
AND POSITION(Tb2.name_id||',',Tb3.NAME_IDS||','