Hi, select * from ytbl_development as t1 where (t1.txtDevPostCode REGEXP "^[[:alpha:]]{1,2}[[:digit:]]{1,2}[[:alpha:]]{0,1}" in #QuotedValueList(qryRadius.shortpostcode)#)
The above Where clause doesn't work , it just seems you can't use REGEXP this way qryRadius.shortpostcode contains a list of "short" postcodes OX14 1,OX14 2 etc whereas t1.postcode contains full postcodes OX14 5RA (If qryRadius.shortpostcode wasn't a list I'd be able to use LIKE) How can I write a Where clause that gets round this MySql 4.018 zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]