>>>>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 >
>>>
>>>Check out CONVERT() in SQL Books Online, e.g.
>>>
>>>select * from arrest
>>>where convert(char(10), date_arrest, 101)="09/01/2000"
>>
>>
>>Woiked like a charm! < G >
>>
>>Thanks,
>
>You're welcome
>
>I'm was raised in your neck o' the woods, so I'm still kind of a Memphian ( or is that Memphibian <g> ) at heart.

Moved from Memphis to New York - I'd call you frustrated, manic and in serious need of a peanut butter and banana sandwich.

-cjh