help regarding subString Replacement
 

Hi All,
i am passing Query as "select * from ab$cd" to the script file variable and running the query from Java Code.
where table name "ab$cd " is taking as ab, after $ its not passing to the Java code.
plz can any one help out this.

To get a sensible answer you'll need to tell us in what
language and how you build the string in the first place.


Cheers,
Tink

hope ab$cd is itself a table and $cd is not a variable.
Try using \ backslash.

For columns we can use them similarly too.

SELECT columns FROM table WHERE
column LIKE '%[%]%'

-- or

SELECT columns FROM table WHERE
column LIKE '%\%%' ESCAPE '\'

Gentoo