Query a column where there are instances of different info

• paul welsh

  SSC Veteran

  Points: 254

  More actions

  May 5, 2005 at 9:58 am

  #164199

  HI,

   

  What keyword, operator or whatever is used when you need to run a query that says "select * from  tblResponses where there are instances of entries in the "Notes" column.

   

  Notes is, as the word suggests, is a box on a web page where the user inserts any notes about the customer. There may not be notes for every record and I need to be able to pull all the rows in the table where notes have been entered.

   

  thanks

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 5, 2005 at 10:01 am

  #557129

  You would have to know which column in the table is associated with the box in the web page.

  Assuming that "Notes" is the column...

  SELECT * FROM tblReponses where Notes is not null

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  May 6, 2005 at 12:25 pm

  #557441

  If there is a possibility of an empty string in that field then:

  SELECT * FROM tblResponses WHERE LEN(Notes) > 0

  would work better!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**