Find All Rows Where a Column's Entry Is greater than a specific size

[mateobus]

Hey,

I have a table called MyTable with a Column called Name which is varchar(50). I would like to write a select statement to get the rows from MyTable where the Name column is greater than 5 characters. So it would select 'blah blah' but not 'blah'. Thanks in advance.

 

[djj55]

SELECT * FROM MYTABLE WHERE LEN(RTRIM(NAME))>5;

The RTRIM will remove blanks on the end.

djj

 

[SQLDenis]

where len(name) > 5

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLDenis]

The RTRIM will remove blanks on the end.

no need for this, len trims but datalength does not

declare @b char(50)
select @b ='aaa     '

select @b,len(@b),datalength(@b)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions