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!

How to add another parameter in here

Status
Not open for further replies.
pectin232

pectin232

Technical User
Jan 22, 2011
67
US
Case when trim(a.DOMESTIC_ADDRESS_LINE1) is null then a.DOMESTIC_ADDRESS_LINE1 else 'Not Available' End Address

I want to also incl if the address has an '' [Empty Set]... but tried different ways and did not work. As I pull data which is null but some are blanks which are '' I believe
 
Status
Not open for further replies.

Similar threads

Toe
  • Locked
  • Question
gettign rid of parameter form
Replies
0
Views
122
Toe
Toe
csphard
  • Locked
  • Question
sequence in which queries run in the data model
Replies
3
Views
182
csphard
csphard
lthomas6
  • Locked
  • Question
Subreport with parameter sorting
Replies
0
Views
113
lthomas6
lthomas6
thatgirl100
  • Locked
  • Question
Reports 6i - Multiple Pages in Report Header?
Replies
0
Views
326
thatgirl100
thatgirl100
fhurmuzlu
  • Locked
  • Question
Converting oracle reports to crystal reports
Replies
0
Views
111
fhurmuzlu
fhurmuzlu

Part and Inventory Search

Sponsor

Back
Top