Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Length of Text Field
Message
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Re: Length of Text Field
Divers
Thread ID:
00922564
Message ID:
00922611
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform