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

["David Thorburn" <thorburn@conl.net>]

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