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!

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

how to display & charcter in striing in oracle ?

Status
Not open for further replies.

ub1234567

Programmer
Dec 4, 2008
69
US
Hi members,

i want to display & in string in oracle.

right now when i am running my script it is asking me to enter variable value and in the out put string it does not display & ..

so how can i display & in string in oracle ?

Thanks.

any help is greatly appreciated.
 
If you mean to show as the output of a formula then just encapsulate in quotes.

e.g.

//{@Stringformula}
'Test' & ' & ' & 'Field2'

Would display as:
Test & Field2

Whereas:

'Test' & 'Field2'

Would show as:

TestField2

I hope this helps to understand how crystal works with ampersands.



CR8.5 / CRXI - Discovering the impossible
 
oops...I didn't even realize the question was asked in a CR forum (I also read and post in Oracle forums on here) and I just responded off the cuff...

We're both correct -- depending on where the & is being used (in CR or in an Oracle query)

-- Jason
"It's Just Ones and Zeros
 
hi jdemmi,

thanks for reply..

i want to used in oracle query nt in CR.

so your mention answer is for oracle query ?

let me know.

thanks/
 
Yes.....see the link I posted

-- Jason
"It's Just Ones and Zeros
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top