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 SkipVought 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
0
0
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
44
Toe
Toe
csphard
  • Locked
  • Question
sequence in which queries run in the data model
Replies
3
Views
72
csphard
csphard
lthomas6
  • Locked
  • Question
Subreport with parameter sorting
Replies
0
Views
32
lthomas6
lthomas6
thatgirl100
  • Locked
  • Question
Reports 6i - Multiple Pages in Report Header?
Replies
0
Views
85
thatgirl100
thatgirl100
fhurmuzlu
  • Locked
  • Question
Converting oracle reports to crystal reports
Replies
0
Views
34
fhurmuzlu
fhurmuzlu

Part and Inventory Search

Sponsor

Back
Top