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

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

ok.

>From next time I won't put naive questions.

In short I was looking for a better and efficent way to code.

Thanks all for your help though the discussion took a detour to India's IIT.

Have a nice day and great week.

Regards.

Ashish Bhatt.


>From: "Knapp, Richard" <KnappR@umsystem.edu>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Dealing with phone numbers in sqr
>Date: Mon, 2 Jun 2003 08:33:05 -0500
>
>
>I'm on Dave's side here.  It seems lately that we are receiving a flood of 
>naive questions that seem to indicate lack of any effort at all to solve 
>the problem on the part of the questioner.  In any case, I don't believe it 
>really helps someone to have the entire problem coded in detail by someone 
>on the list who has a solution.
>
>Richard Knapp
>Database Programmer/Analyst
>Institutional Research and Planning
>University of Missouri System
>573-882-8856
>knappr@umsystem.edu
>
>
>-----Original Message-----
>From: Hood Louise (app1lxh) [mailto:app1lxh@ups.com]
>Sent: Monday, June 02, 2003 7:59 AM
>To: 'sqr-users@sqrug.org'
>Subject: RE: [sqr-users] Dealing with phone numbers in sqr
>
>
>Varsha,
>
>You're far too rough on poor David.  He's not racist.  He just views the
>rest of us as truly loathesome creatures, not real programmers like he is.
>When he's not programming, his favorite pasttime is sneering.
>
>Pardon me while I duck.
>L
>
>-----Original Message-----
>From: Varsha Das [mailto:vdas@mail.ucf.edu]
>Sent: Friday, May 30, 2003 10:03 AM
>To: sqr-users@sqrug.org
>Subject: Re: [sqr-users] Dealing with phone numbers in sqr
>
>
>David,
>
>This is an SQR users group, and not a slam-people group. This is where you
>go to get help on writing SQR code. If you have a problem with that perhaps
>this is not the group for you? I'm sure you are a crack SQR programmer, and
>don't need anothing except a SQR manual to look at, but not all of us are,
>and this forum is a place to get help from other folks who may have a quick
>answer to a question.
>
>Why the slam on IIT? I'm not a graduate from IIT (nor do I know the person
>who asked the question in the first place) but your comment sounded racist
>to me.
>
>Regards,
>
>Varsha.
>
> >>> thorburn@conl.net 5/29/2003 8:06:56 PM >>>
>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
>
>_______________________________________________
>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