Wednesday, March 14, 2012

Len in SQL

create table tableLen(stdname varchar(50))

insert into tableLen values ('abi')
insert into tableLen values ('paranthaman')
insert into tableLen values ('ramesh')
insert into tableLen values ('raj')
insert into tableLen values ('sah')

select * from tableLen where Len(stdname) >  3

output
--------
paranthaman
ramesh

No comments:

Post a Comment