Re: [sqr-users] Dealing with phone numbers in sqr

["Ashish Bhatt" <ashish_bhatt@hotmail.com>]

David, IIT is no.1 in the world. Bill Gates also mentioned this in his last 
visit to India.

Thanks for your email.

Have a nice day and great weekend.

Regards.

Ashish Bhatt.

>From: "David Thorburn" <thorburn@conl.net>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] Dealing with phone numbers in sqr
>Date: Thu, 29 May 2003 17:06:56 -0700
>
>Ashish,
>
>I have done this type of programming many times.
>
>The catch is that you have to KNOW the language well enough to code!
>
>I guess they don't tech real coding at IIT...?  Only resume writing...?
>
>SQR is a programming language!  Learn it and you will have no problems.
>
>      [ Hint: Delimiters, Concatenation ]
>
>Regards,
>
>David
>
>----------------------------------------------------------------------------
>-----------------
>
>----- Original Message -----
>From: "Prasanna Menta" <pmenta@umuc.edu>
>To: <sqr-users@sqrug.org>
>Sent: Thursday, May 29, 2003 11:22 AM
>Subject: Re: [sqr-users] Dealing with phone numbers in sqr
>
>
> > USE THE SUBSTR OR REPLACE FUNCTION
> > Example replace(Column,<what to replace>,<with what>)
> > hope this helps
> > Prasanna
> >
> > Ashish Bhatt wrote:
> > >
> > > Hi All SQR Gurus,
> > >
> > > I hope you are doing fine today.
> > >
> > > I am writing a sqr in which I need to give the user the phone numbers 
>10
> > > digits in the format 9999999999.
> > >
> > > My problem is that I have the phone numbers as (123)-456-7890 or
> > > 123-456-7890. How to convert these to 1234567890 ?
> > >
> > > Has anyone done this before in SQR ?
> > >
> > > If yes, please share with me.
> > >
> > > Thanks in advance.
> > >
> > > Have a nice day and great week.
> > >
> > > Regards.
> > >
> > > Ashish Bhatt.
> > >
> > > _________________________________________________________________
> > > Find gifts, buy online with MSN Shopping. http://shopping.msn.com.sg/
> > >
> > > _______________________________________________
> > > sqr-users mailing list
> > > sqr-users@sqrug.org
> > > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Download Norah Jones, Eminem and more! http://www.msn.com.sg/ringtones/ at 
only S$36 including GST

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users