substring command not taking $ symbol in string

[abhishek20c]

Hi when i am doing any string operation using SUBSTR on a string containing '$' then the SUBSTR commnad is taking string upto '$' only.
For example ABCD$defg then the SUBSTR will consider ABCD only as string.

What is the alternate method of writing the string having $ so that it will be taken as complete string.

[arjunsinghsamant]

replace that :

select replace(substr( replace(substr( 'ABCD$defg',1), '$','r'),1,9),' r','$') from sysibm.sysdummy 1


is it works well as per ur need?