PSC SQL - splitting data

[miss_mystikal]

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? To unsubscribe, send an email to: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/PlanetSourceCode/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --- 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