Results 1 to 2 of 2

Thread: update query

  1. #1
    Join Date
    May 2003
    Posts
    40

    Unanswered: update query

    Folks

    I m trying to load data from the same table in one database to the second database.

    The data in the first database branch table is

    ex,<null>,<null>,<null> in the three fields.




    sCommand_DiscRevDev.CommandText = "UPDATE Branch" & _
    " set Branch_Nm = '" & RTrim(Replace(drCode("Branch_Nm"), "'", "''")) & "'," & _

    " Addr_line_1_Tx = '" & drCode("Addr_line_1_Tx") & "', " & _

    " Addr_line_2_Tx = '" & drCode("Addr_line_2_Tx") & "'

    " where Branch_Cd = " & drCode("Branch_Cd") & " "



    The result set is

    update branch set branch_nm='ex',addr1='',addr2=''
    where branch_cd = 1


    The data is load as a an emptry string ie the word "NULL"
    is not appearing the query.

    Can you suggest what function do I need to use to get the word NULL in the update
    query.



    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ISNULL(Column,'NULL')?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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