Use substitution variables in a string
 
SQL*XL user Wilhelm from Germany asked the following question:
 
Question:
When I run the following query I do not get any results:
select * from mytable where mycol like '&parameter%';
 
Answer:
Parameters in strings did not work properly. I have put a fix in for this. It will be released as SQL*XL 4.0.6.
The query you mention now works properly.
 
It raises an interesting question. Suppose you want to query an &:
[tt]select 'a&b' from dual
a&b
 
When you run the above query SQL*XL will see the &b as a variable and it will ask you for a value. If you just want to return the a&b you need to escape the & symbol:
set escape on;
select 'a\&b' from dual;  
 
References:
SQL*XL home page: www.oraxcel.com/projects/sqlxl
Set command: www.oraxcel.com/projects/sqlxl/help/commands/set.html