Re: how do I select len(foo) for an ntext field?
From: marty (marty_at_discussions.microsoft.com)
Date: 05/06/04
- Next message: Hugo Kornelis: "Re: => Unorthodox DB Updates - Trigger order"
- Previous message: Rhonda Fischer: "=> Unorthodox DB Updates - Trigger order"
- In reply to: Vishal Parkar: "Re: how do I select len(foo) for an ntext field?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 May 2004 09:40:04 -0700
yup that worked! thanks.
"Vishal Parkar" wrote:
> 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: Hugo Kornelis: "Re: => Unorthodox DB Updates - Trigger order"
- Previous message: Rhonda Fischer: "=> Unorthodox DB Updates - Trigger order"
- In reply to: Vishal Parkar: "Re: how do I select len(foo) for an ntext field?"
- Messages sorted by: [ date ] [ thread ]
