Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find a shorter text on a longer column?
Message
From
12/12/2006 17:32:35
Sergey Berezniker
New York, United States
 
 
To
12/12/2006 16:29:23
Alex Feldstein
Florida, United States
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:
01176991
Views:
6
>>You can use LIKE operator. It's optimizable as long as it doesn't start with wildcard character.
>WHERE trandate LIKE LEFT(myexceldate,10) + '%'
>
>That worked, fast enough. Thx.

You're welcome.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform