Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GMORA
  • Order by date
  1. GMORA

    Convert Blank Value to Hyphen

    Yes, you are correct, that will create the dash. now the problem is on the ELSE portion it says a string is required here so I did totext({amount1}) and it seems to work. Do you see any problems with that solution? if isnull({amount1}) then "-" else totext({amount1})
  2. GMORA

    Convert Blank Value to Hyphen

    Hi everyone, been working on this to long and need some help. CR 11/sql2005 Current Output Amount 1 Amount 2 1.00 2.00 0.00 Desired Output as follows: Amount 1 Amount 2 1.00 2.00 - 0.00 Desire is to show a hyphen where blank...

Part and Inventory Search

Back
Top