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
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
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
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
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
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.