RE: PSC SQL - splitting data

[Jesse Bryant]

Title: Re: PSC SQL - splitting data





That 
will work but if it's a one digit number it'll be simpler to use..... oh what is 
it now... Right()?
 
Jesse.

  -----Original Message-----From: sanat kumar mishra 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, 27 
  October 2004 4:48 PMTo: 
  [EMAIL PROTECTED]Subject: Re: PSC SQL - splitting 
  data
  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 > 


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.