Message
From
12/12/2006 13:40:48
Alex Feldstein
Florida
,
United States
To
12/12/2006 13:36:24
Borislav Borissov
(Online)
Microcomplex
Sofia
,
Bulgaria
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re:
How to find a shorter text on a longer column?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01176930
Message ID:
01176941
Views:
12
>>PS: Would SQL syntax be:
>>
>>... "
AND
trandate
LIKE
'" + LEFT(myexceldate,10) + "%'"
>>
>
>Where you write this?
>In QA no, if you write it in VFP program or IDE, yes.
VFP of course! :)
Alex Feldstein, MCP,
Microsoft MVP
VFP Tips:
English
-
Spanish
Website
-
Blog
-
Photo Gallery
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only