Character Count

fgrubercpa

New Member

Join Date: Aug 2013

Posts: 2
#1

Character Count

Nov 4 '13, 01:08 AM

Is there a T-SQL Command that will allow me to SELECT, for example, every ROW where a COLUMN has a specific number of Text Characters? like,

Code:

SELECT * WHERE TEXT_COLUMN (CHARACTERCOUNT>3000)???

THANKS
F

Last edited by Rabbit; Nov 4 '13, 05:20 AM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
Tags: None
pdross2000

New Member

Join Date: Nov 2012

Posts: 1
#2

Nov 4 '13, 02:06 AM

Code:

select * from table where len( columnname) > 3000

Last edited by Rabbit; Nov 4 '13, 05:20 AM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
Comment

Comment