Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: pls help w/data conversion
Maybe something like:
decode(substr(namefield,length(namefield),1),'s',namefield||'''',namefield)
Interpretation:
check for 's' as the last character. If so, append a single quote to end, if not leave in original form.
Regards,
Ian Received on Sun Jul 22 2001 - 06:52:31 CDT