Select ..matches doesnt't work

Posted in 1999

Topics: SQL Development & Query Writing, Server Administration

Michel Marcon — Thu, 09 Sep 1999 09:00:40 GMT — source: Informix-list mailing list archive (1991-1998)

Hi A select statements works on SE v4.x but doesnt' work on SE7.x Exemple with dbaccess (my name is marcon) SELECT * FROM AGENT WHERE "MARC%" LIKE agent.name Am I missing a new "wildchar" or something ??? cmic Thx to help !

↪ replying to Michel Marcon

Rob Prop — Thu, 09 Sep 1999 11:25:09 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, Try the following syntax: WHERE fieldname LIKES "string%" OR WHERE fieldname LIKE "string*" This should work Greetings, Rob Prop Michel Marcon wrote: > Hi > > A select statements works on SE v4.x but doesnt' work on SE7.x > Exemple with dbaccess (my name is marcon) > > SELECT * FROM AGENT WHERE "MARC%" LIKE agent.name> > Am I missing a new "wildchar" or something ??? > > cmic > Thx to help !

↪ replying to Rob Prop

Christian Brauer — Thu, 09 Sep 1999 11:38:18 +0200 — source: Informix-list mailing list archive (1991-1998)

Sorry, don't think that will work WHERE fieldname LIKES "string%" has to be WHERE fieldname LIKE "string%" where the '%' mean only one character position. WHERE fieldname LIKE "string*" has to be WHERE fieldname MATCHES "string*" Hth, Christian Brauer

Glossary

dbaccess