Exclude null text field from query

• Thuan Pham

  Old Hand

  Points: 365

  More actions

  June 24, 2005 at 7:58 am

  #167516

  Hi I have a table with a text field: fmtrkno. I want to create a query to exclude all rows with that text field being null. I tried these and they didn't work: where fmtrkno is not null or convert(char(20), fmtrkno) is not null or (CAST(fmtrckno AS char(20)) IS NOT NULL). I also tried the IsEmpty(fmtrkno) but this is not an SQL function. Please help. Thank you

• June 27, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 27, 2005 at 8:22 am

  #568616

  Does something like this not work?

  SELECT * FROM foo WHERE bar IS NOT NULL

  If not, could you provide DDL and some sample data, along with a description of the desired output.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Mohammad Sufian

  Ten Centuries

  Points: 1292

  More actions

  June 27, 2005 at 9:36 pm

  #568797

  Hi,

  There r many ways to remove the null from the tables when u execute sql statement .

  If u want to see the records or insert then u can use something like this.

  Select * from tablename where columnname!=''

   

  Select * from tablename where columnname is not null

  insert into tablename select * from tablename where columnname is not null

   

  from

  sufian