Replace null values with "-"

Results 1 to 3 of 3

Thread: Replace null values with "-"

  1. #1
    Join Date
    Dec 1969

    Default Replace null values with "-"

    I would like to replace my null values in the database with a "-".I try doing something like this but it doesnt work.Can someone correct my codes?<BR><BR>Select IsNull(sccpch_load_denom_0,-) AS sccpch_load_denom_0 from W_CEll<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Replace null values with

    do you want to actually update the field? with that Select statement, you&#039;re NOT updating anything. You are just replacing it when you&#039;re doing a select...<BR><BR>you need an update statement:<BR><BR>update W_CELL set sccpch_load_denom_0 = &#039;-&#039; where<BR> sccpch_load_denom_0 is null

  3. #3
    Join Date
    Dec 1969

    Default bad syntax

    Select IsNull(sccpch_load_denom_0,-) AS sccpch_load_denom_0 from W_CEll <BR><BR>to<BR><BR>Select IsNull(sccpch_load_denom_0,&#039;-&#039;) AS sccpch_load_denom_0 from W_CEll

Posting Permissions

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