hy there !!!
i tried to make a search-site on a db2 database and all the tutorials are for access.
the problem is, that db2 doesn't support the "LIKE" sql command.
does anybody know a way to do that without the "LIKE" command ?
thx...

<font face='Arial'>have you tried using the = operator?</font id='Arial'>

...is this thing on?

Hello there,

I got a site running on an IBM AS-400 with DB-2 Enterprise Edition. Now on your question the LIKE sql command works perfectly with DB2, some tips on the string you would the search for :
%ABC would mean that you search for anything untill it reached C
ABC% would mean that you search for anything starting from A
%ABC% would mean you search for anything before and after C

Otherwise, just paste your SQL in a message and ill have a look at it.

Greetings from Canada
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hy there !!!
i tried to make a search-site on a db2 database and all the tutorials are for access.
the problem is, that db2 doesn't support the "LIKE" sql command.
does anybody know a way to do that without the "LIKE" command ?
thx...


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Dave Joosten