Re: how do I select len(foo) for an ntext field?
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/05/04
- Next message: Rhonda Fischer: "Re: => Trigger to split Trailer Loads"
- Previous message: Mehran: "indexing problem"
- In reply to: marty: "how do I select len(foo) for an ntext field?"
- Next in thread: marty: "Re: how do I select len(foo) for an ntext field?"
- Reply: marty: "Re: how do I select len(foo) for an ntext field?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 May 2004 15:24:57 +0530
hi marty,
select datalength (column) from <table>
The datalength function returns the number of bytes. Because you are using
an ntext data type, divide it by 2 if you want to know the number of
characters occupied.
-- Vishal Parkar vgparkar@yahoo.co.in | vgparkar@hotmail.com
- Next message: Rhonda Fischer: "Re: => Trigger to split Trailer Loads"
- Previous message: Mehran: "indexing problem"
- In reply to: marty: "how do I select len(foo) for an ntext field?"
- Next in thread: marty: "Re: how do I select len(foo) for an ntext field?"
- Reply: marty: "Re: how do I select len(foo) for an ntext field?"
- Messages sorted by: [ date ] [ thread ]
