>How can we use LEN() on a Text field in SQL Server? I see this works for a Char field but what about a Text field?
Do not use Text fields. use n/varchar(max) instead.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.