Any alternative for Substrings function?

[sumesh.abraham]

Hi All,

I've a requirement. The input column data is of 10 digits and the output should be of 9 digits, with the second digit removed.Substrings function works perfectly fine.Now I want to know of any other function which does the same work more efficiently.

[sachin1]

hello dear taking your request into consideration,

following could help you,

suppose your string is str1=;1234567890' so your output will be like str1[3,10]:str1[1,1]

and the output is like 345678901

this is one of the method i think is efficient.

[ray.wurlod]

Substring and concatenation is almost certainly the most efficient. Arithmetic (with Int() and Mod() functions) will be a close second.