Wild Character Help

[=?Utf-8?B?UGxheWE=?=]

I am trying to use a wild character in the LIKE part of my select statement
for connecting to an AS400 database table and can't get it to work properly.
I can get it to work when I hard code the value in. See below...

strSelectStr = New IBM.Data.DB2.iS eries.iDB2Comma nd("select * from
LIBRARY.CKTIMEF LK5 where TICONO=1 and TIEMPN= 1710 and TIRTIM
LIKE '20070207%'", cn)

However when I try to use a variable that is holding the value I can't get
it to work properly. Below is one of the methods I tried, however it doesn't
match a record and I know that 20070207 is the value of intCardDate.

strSelectStr = New IBM.Data.DB2.iS eries.iDB2Comma nd("select * from
KITDATA.CKTIMEF LK5 where TICONO=1 and TIEMPN= 1710 and TIRTIM LIKE '" &
"'" & intCardDate & "'%'" & "'" & "'", cn)

Can anyone help me out with how I should properly code my LIKE statement.
Thanks in advance.

[jayeldee]

On Mar 13, 11:03 am, Playa <P...@discussio ns.microsoft.co mwrote:

strSelectStr = New IBM.Data.DB2.iS eries.iDB2Comma nd("select * from
KITDATA.CKTIMEF LK5 where TICONO=1 and TIEMPN= 1710 and TIRTIM LIKE '" &
"'" & intCardDate & "'%'" & "'" & "'", cn)

Can anyone help me out with how I should properly code my LIKE statement.
Thanks in advance.

If I'm not mistaken, it looks like you have an extra apostrophe around
the intCardDate value. To make sure you should try setting a variable
and using string.format like so:

dim sQuery as String = String.Format(" Select * From KITDATA.CKTIMEF LK5
Where TICONO=1 and TIEMPN = 1710 and TIRTIM Like '{0}%'",intCard Date)

Then set the Command's CommandText to squery. If that doesn't work
then I'd break in the debugger and copy the value out for sQuery and
try running it manually against the data source to verify your syntax.