DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: MSSQL TO oracle

Threaded View

  1. #7
    Join Date
    Jan 2005
    Posts
    221
    NO, it's parameter

    I have the parameter @user_id. I want all records if the parameter has a NULL value. I only want records that match the parameter if the parameter is not null. Because the parameter can be null, I have to cast it to a varchar before I send it into the UPPER function in MSSQL
    Last edited by hannah00; 07-05-2005 at 03:23 PM.

Posting Permissions

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


Click Here to Expand Forum to Full Width