Re: [firebird-support] Problem in executing query using 'IN' statement.

ort@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 16 September 2016 22:23 To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Problem in executing query u

Re: [firebird-support] Problem in executing query using 'IN' statement.

ent:* 16 September 2016 22:23 *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Problem in executing query using 'IN' statement. Den 16.09.2016 15:34, skrev 'Joje' j...@codework-solutions.com <mailto:j...@codework-solutions.com> [firebird-support]: I have a query

RE: [firebird-support] Problem in executing query using 'IN' statement.

rd-support] Problem in executing query using 'IN' statement. Den 16.09.2016 15:34, skrev 'Joje' j...@codework-solutions.com <mailto:j...@codework-solutions.com> [firebird-support]: I have a query in which I check whether an NAME _IDS of type varchar is in another table with NAME _ID column

Re: [firebird-support] Problem in executing query using 'IN' statement.

Den 16.09.2016 15:34, skrev 'Joje' j...@codework-solutions.com [firebird-support]: I have a query in which I check whether an NAME _IDS of type varchar is in another table with NAME _ID column having data type as int. Also, ID_1 have ID’s separated by comma’s example ‘1,2,3,4,5’. Below is

Re: [firebird-support] Problem in executing query using 'IN' statement.

On Friday, September 16, 2016 4:35 PM, "'Joje' j...@codework-solutions.com [firebird-support]" 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

[firebird-support] Problem in executing query using 'IN' statement.

Hi All, I have a query in which I check whether an NAME _IDS of type varchar is in another table with NAME _ID column having data type as int. Also, ID_1 have ID's separated by comma's example '1,2,3,4,5'. Below is the query which I am trying to execute SELECT Tb2.