#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    3
    Rep Power
    0

    SUBSTR function on a null column?


    How do you use the SUBSTR function on a column that is null?

    What happens when you use a function (like substring) on a column that IS NULL? This is the question for a class I'm taking and I just don't get it for some reason.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by TwistedFate
    How do you use the SUBSTR function on a column that is null?
    the exact same way that you'd use it on a column that isn't NULL

    Originally Posted by TwistedFate
    What happens when you use a function (like substring) on a column that IS NULL?
    two helpful suggestions:

    1. test it

    2. read da manual


    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo