Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Length of Text Field
Message
General information
Forum:
ASP.NET
Category:
Databases
Title:
Re: Length of Text Field
Miscellaneous
Thread ID:
00922564
Message ID:
00922611
Views:
14
Danny,

If I change the WHERE clause to be

DATALENGTH(field1) > 1

it works great. Thanks for the quick reply!

Kind Regards,

Mat


>Matthew,
>
>On SQL Server you must use DATALENGTH rather than Len for Text Fields...
>
>Hope that helps...
Matthew Kennedy
Decision Support Technology Inc.

"I try to take one day at a time, but sometimes several days attack me all at once." ~ Ashleigh Brilliant

New Jersey Dot Net User Group
Previous
Reply
Map
View

Click here to load this message in the networking platform