Trying to make this work on VFP tables accessed via odbc:
TEXT TO mystring NOSHOW TEXTMERGE
SELECT * FROM tbl_main WHERE CAST(LEFT(Number, PATINDEX('%[-, /\@#$%^!&*()+A-Z]%', Number + 'A')-1) AS int) = 111 AND street = 'JONES' AND st_type = 'RD'
ENDTEXT
The exact same syntax works in SQL2000/SQL2005 but not when the backend is VFP tables accessed via odbc.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"