+ Reply to Thread
Results 1 to 3 of 3
  1. 08-19-2005 05:06 AM #1
    stevefox
    stevefox is offline Junior Member
    Join Date
    May 2005
    Posts
    2

    How to search for all names with exactly 8 characters long in SQL.

    Could someone please tell me the SQL script for searching for all names in a table with exactly 8 characters long?
    Reply With Quote Reply With Quote
  2. 08-19-2005 09:10 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    WHERE length(foo) = 8
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
  3. 08-24-2005 05:32 AM #3
    ketan346
    ketan346 is offline Junior Member
    Join Date
    Aug 2005
    Posts
    1
    Hi Friend,

    U can use

    select * from tablename where length(name) = 8 ;

    bye
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width