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!

White Space in parameter Question

Status
Not open for further replies.

croag

MIS
Nov 8, 2001
49
US
Hello all,

I know this is probably elemetary - but I cannot for the life of me get variable that contains a white space. I.E.:


..
..
and STIIHE.TEAM_ASSIG='0' and DDIT.T_NO = '&TEAMNAME'


When Prompted, a value like TEAM_A works fine - However, when I enter a value like TEAM A,(which is a seperate team from TEAM_A, it sees as if the variable doesn't like the white space between TEAM and A.


Is this just an issue of single quotes and double quotes? Thanks for your help!
 
Croag,

It would be helpful, to see your entire code segment, including the code you are using to populate the 'variable'. I, personally, don't encounter a problem with white space in prompted-for replacement label such as "TEAMNAME":
Code:
accept teamname prompt "Enter a value for teamname: "
select '&teamname' from dual
where '&teamname' = 'This is my entry'
/

Enter a value for teamname: This is my entry

'THISISMYENTRY'
----------------
This is my entry
So, I'm not seeing a problem on my end. Please post your code so that I can test it out in its entirety.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top