Looking for a Function Like Mid in VB6 That does the same in oracle [Archive]

Click to See Complete Forum and Search --> : Looking for a Function Like Mid in VB6 That does the same in oracle

shachar

Oct 19th, 2000, 05:32 AM

i have a numeric column in my database and i want to get only to Chars out of the data in that column which is a number i m looking for the function that will do the same as mid in vb6 does

crispin

Oct 19th, 2000, 08:06 AM

I think the function you're looking for is SubStr in PL/SQL