 |
 |
Archives of the TeradataForum
Message Posted: Thu, 22 Sep 2005 @ 10:25:01 GMT
| Subj: | | Re: Query to get the last space in a string. |
| |
| From: | | Sheetal Wali |
sanjaya.nagabhushan wrote:
| | You are better off trying a UDF or a TDSP but the query below does the job. It assumes that your string only has alphabets and numbers
based on the example that you provided. In case there are other characters, You can add additional trim clauses. | |
Thanks for your reply , but if I try to use the same query for other strings like 'anthem healthcare insurance'.It does not give me the
required postion of the space.
| |
