Similar to:

select count(*) from v$session
where length(username) > 2;

-----Original Message-----
From: Bill Ducker [mailto:bill.[Email Address Removed] Monday, June 30, 2003 12:44 PM
To: LazyDBA.com Discussion
Subject: A Simple SQL Question


My table has a VARCHAR2(100) column. Most of the rows have two characters
('AL', 'RS', etc.) in this column. Some, however, have much more ('American
Board of Surgeons', etc.). How do I write a SELECT COUNT(*) FROM tablename
WHERE... statement to count the rows which have something more than two
characters?



William L. (Bill) Ducker
Mainframe Database & Security Administrator
ADABAS 7.1.2, Oracle 9i
Texas Workers' Compensation Commission
bill.[Email Address Removed] 804-4974

--- Any opinions in this message are mine, and do not
represent official TWCC policy.


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

This communication is intended for the use of the recipient to which it is
addressed, and may contain confidential, personal and or privileged
information. Please contact us immediately if you are not the intended
recipient of this communication, and do not copy, distribute, or take action
relying on it. Any communication received in error, or subsequent reply,
should be deleted or destroyed.
Oracle LazyDBA home page