I'm trying to extract data from a SQL 7.0 table using sqlstringconnect. If I issue lcsql='select * from arrest ' for the sql select code, it works. However, I want to pull data for one specific date. If I try "select * from arrest where date_arrest like 09/01/00", I get no return. I've tried wildcards and it ain't happening. Would one of you SQL folks care to shed a little light on me?< G >
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright