Hi All,
Can someone tell me how to remove the double quote from the first position of the field value as below
"12345678
Thanks
Removing a charecter from the first position of the value
Moderators: chulett, rschirm, roy
Code: Select all
RIGHT(In.Column,LEN(In.Column)-1)
Code: Select all
TRIM(In.Column,'"')
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>