Results 1 to 2 of 2

Thread: MySQL Mystery

  1. #1
    Join Date
    Sep 2004

    Unanswered: MySQL Mystery

    Good morning ye all noble software people!

    When I add a "Dest_carrier" VARCHAR(3) field to a "destinations" table, that field contains nothing. As I gradually fill in values and want to display only the records in which that field is not yet filled in

    > how do I spell the SQL statement < ?

    Select * from destinations
    where Dest_carrier = NULL doesn't do the trick

    nor does
    where Dest_Carrier = ''

    nor does
    where len(trim(Dest_Carrier)) = 0

    Thank you profusely for helping me to save my week-end !

    John in Belgium

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    where Dest_carrier is null | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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