Selecting based upon length of field in database..

• interclubs

  SSC Enthusiast

  Points: 135

  More actions

  February 1, 2002 at 8:20 am

  #77775

  I am trying to do a select to determine if I have a field over x characters, but I can't seem to get it to work in SQL...Something like this:

  select * from news where length(title)> 8000

  (works in oracle)

  Thanks!

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  February 1, 2002 at 8:49 am

  #422944

  In SQL Server the same function is LEN(). So the query would look as follows:

  SELECT *

  FROM news

  WHERE LEN(title) > 8000

  I'm assuming title is a text or ntext field?

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley