Hi
I can write a query such
where left(t1.txtDevPostCode,5) in
(#QuotedValueList(qryRadius.postcode)#)
but unfortunately UK postcodes are variable length
SO I really want something like
where REGEXP(t1.txtDevPostCode,"^[a-z]{1,2}[0-9]0,2}") in
(#QuotedValueList(qryRadius.postcode)#)
This use of REGEXP doesnt exist AFAIK , what work arounds exist, or
how would you do it?
BTW the QuotedValueList contains "Short Postcodes of type AA11 or A11
or AA1
zzapper
--
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]
