Changeto query

[cooperboy]

I have a field that is character and would like to get rid of first three character values. For example, the data looks like this:

xyz1000001
xyz1000002
xyz1000003

and after the changeto query the data should look like this:

1000001
1000002
1000003

Can I do this in a changeto query or do I need a script?

 

[TonyMcGuire]

You *can not* do this with a query.

Script could, likely with a tcursor and substr().



Tony McGuire

http://www.thedbaddons.com

http://www.thedbcommunity.com