USE MID FUNCTION AND INSIDE IT USE THE INSTR TO GET THE POSITION OF THE CHARACTER U R SEARCHING.
On Wed, 27 Oct 2004 miss_mystikal wrote : >Hi, how to split data like this: > >0000023674 - V4 > >I want to get the number after �V�. > >Can we do it in SQL? I have one table and they are thousand records with >similar id. > >Instead of using loop in VB, is there any other way to cut the number? > > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.762 / Virus Database: 510 - Release Date: 9/13/2004 >
