Select * bla, Where CHAR_LENGTH > 10??

Results 1 to 2 of 2

Thread: Select * bla, Where CHAR_LENGTH > 10??

  1. #1
    ASP_DRUG_DEALER Guest

    Default Select * bla, Where CHAR_LENGTH > 10??

    I have some user PROFILES stored in a SQL 7 table. Some users spend more time filling out their profile then others, so I would like to only pick the ones that have X amount of characters. Anyone know if I can do this? <BR><BR>Thanks,<BR>Drug Dealer

  2. #2
    John Weeflaar Guest

    Default RE: Select * bla, Where CHAR_LENGTH > 10??

    Try this:<BR>Assuming the field name is profiles (Text data type) and the table name is tbluser (This will work in Access, and should do also in SQL):<BR>Suppose X is 10 (The max. number of characters wanted):<BR>SELECT *<BR>FROM tbluser<BR>WHERE Len(profiles) &#060;= 10<BR><BR>John

Posting Permissions

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