Loading ...
Sorry, an error occurred while loading the content.

Re: [SQLQueriesNoCode] number of digits

Expand Messages
  • Peter Brunone
    Todas las palabras parecen aplastado juntos en Gmail. On Thu, Apr 17, 2008 at 3:56 PM, Cesar ROUILLON SIXTO
    Message 1 of 15 , Apr 17, 2008
    • 0 Attachment
      Todas las palabras parecen aplastado juntos en Gmail.

      On Thu, Apr 17, 2008 at 3:56 PM, Cesar ROUILLON SIXTO <
      cesar_rouillon@...> wrote:

      >
      > los espacios? Saludos coordialmente ROUILLON SIXTO César E.Ing. en
      > Informática y SistemasCel: +51 (01) 80073180Perú
      >
      > To: SQLQueriesNoCode@yahoogroups.comFrom<SQLQueriesNoCode%40yahoogroups.comFrom>:
      > peter.brunone@... <peter.brunone%40gmail.comDate>: Thu, 17 Apr
      > 2008 15:22:44 -0500Subject: Re: [SQLQueriesNoCode] number of digits
      >
      > De nada. ¿Adonde van los espacios en tu mensaje?On Thu, Apr 17, 2008 at
      > 3:07 PM, Cesar ROUILLON SIXTO <cesar_rouillon@...<cesar_rouillon%40hotmail.com>>
      > wrote:>> thanks to the peopple = gracias a toda la gente>> Regards=Saludos
      > ROUILLON SIXTO César E.Ing. en Informática y SistemasCel:> +51 (01)
      > 80073180Perú>> To: SQLQueriesNoCode@yahoogroups.comFrom<SQLQueriesNoCode%40yahoogroups.comFrom><SQLQueriesNoCode%40yahoogroups.comFrom>:>
      > peter.brunone@... <peter.brunone%40gmail.comDate><peter.brunone%40gmail.comDate>: Thu, 17 Apr> 2008 14:53:29 -0500Subject:
      > Re: [SQLQueriesNoCode] number of digits>> Show us the whole error message,
      > please.To replace a character in SQL, you> would do something like
      > this:UPDATE JugadorSET Jug_Celular => REPLACE(Jug_Celular, '-', '')On Thu,
      > Apr 17, 2008 at 2:46 PM, Cesar ROUILLON> SIXTO <cesar_rouillon@...<cesar_rouillon%40hotmail.com><cesar_rouillon%
      > 40hotmail.com>> wrote:>>> Thanks> 1) but I can't update because I get this
      > message Time is expired,>>> What I can to do?>> 2) I have numbers of
      > telephone of the form 99178681> updating is 999178681> but I too have
      > numbers of the form 991-78681 How I> can for update to:> 999178681 (delete
      > the " - ") Thanks Regards ROUILLON> SIXTO César E.Ing. en> Informática y
      > SistemasCel: +51 (01) 80073180Perú>>> To:
      > SQLQueriesNoCode@yahoogroups.comFrom<SQLQueriesNoCode%40yahoogroups.comFrom><SQLQueriesNoCode%40yahoogroups.comFrom><SQLQueriesNoCode%40yahoogroups.comFrom>:>>
      > john@... <john%40jwarner.comDate> <john%40jwarner.comDate>
      > <john%40jwarner.comDate>:> Thu, 17 Apr 2008 14:54:22> -0400Subject: RE:
      > [SQLQueriesNoCode] number of> digits>> Good catchJohn Warner> -----Original
      > Message-----> From:>> SQLQueriesNoCode@yahoogroups.com<SQLQueriesNoCode%40yahoogroups.com><SQLQueriesNoCode%
      > 40yahoogroups.com><SQLQueriesNoCode%> 40yahoogroups.com>>> [mailto:
      > SQLQueriesNoCode@yahoogroups.com <SQLQueriesNoCode%40yahoogroups.com>
      > <SQLQueriesNoCode%40yahoogroups.com>> <SQLQueriesNoCode%40yahoogroups.com>]>
      > On Behalf Of Peter Brunone> Sent:> Thursday, April 17, 2008 2:52 PM> To:>
      > SQLQueriesNoCode@yahoogroups.com <SQLQueriesNoCode%40yahoogroups.com>
      > <SQLQueriesNoCode%40yahoogroups.com><SQLQueriesNoCode%> 40yahoogroups.com>>>
      > Subject: Re: [SQLQueriesNoCode] number of digits> >> Except "less than or>
      > equal to" would be <=8...> > :D> > Peter> > P.S. If> validation is working>
      > correctly, he shouldn't have any numberswith> less> than 8 digits...> > On>
      > Thu, Apr 17, 2008 at 1:45 PM, John Warner <> john@...<john%40jwarner.com><john%
      > 40jwarner.com><john%40jwarner.com>>> wrote:> > >> I'd switch to less then
      > or equal to >=8 just to be safe.> >> >> John Warner>> >> > > -----Original
      > Message-----> > > From:>>> SQLQueriesNoCode@yahoogroups.com<SQLQueriesNoCode%40yahoogroups.com><SQLQueriesNoCode%
      > 40yahoogroups.com><SQLQueriesNoCode%> 40yahoogroups.com><SQLQueriesNoCode%40yahoogrou>>
      > ps.com>> > > On Behalf> Of Michael Weiss> > >> > >> > > Try something
      > like> this...> > >> > > Update> m> > >> > > SET m.PhoneNumber = '9' +>
      > m.PhoneNumber> > >> > > FROM myTable> AS m> > >> > > WHERE
      > LEN(m.PhoneNumber)> = 8> > >> > >> > >> > > Best> Regards,> > >> > >
      > Michael> > >> > >> > >> > >> _____> > >> > > From:>>
      > SQLQueriesNoCode@yahoogroups.com <SQLQueriesNoCode%40yahoogroups.com><SQLQueriesNoCode%
      > 40yahoogroups.com>> <SQLQueriesNoCode%40yahoogroups.com><SQLQueriesNoCode%40yahoogrou>>
      > ps.com>>> > >> [mailto:SQLQueriesNoCode@yahoogroups.com<SQLQueriesNoCode%40yahoogroups.com>
      > <SQLQueriesNoCode%40yahoogroups.com>> <SQLQueriesNoCode%40yahoogroups.com><SQLQueriesNoCode%40yah>>
      > oogroups.com>]>> > On Behalf Of Cesar> > > ROUILLON SIXTO> > > Sent:>
      > Thursday, April 17,> 2008 10:12 AM> > > To:>>
      > sqlqueriesnocode@yahoogroups.com <sqlqueriesnocode%40yahoogroups.com>
      > <sqlqueriesnocode%40yahoogroups.com><sqlqueriesnocode%> 40yahoogroups.com>>
      > <sqlqueriesnocode%40yahoogroups.co> m>> > > Subject:> RE:>
      > [SQLQueriesNoCode] number of digits> > >> > >> > >> > >> > > Hi> friends> >>
      > >> > > How I can to know the number of digits of a value of a> table?> > >>
      > there is a function?> > >> > > UPDATE JugadorSET Jug_Celular => 900000000 +>
      > (SELECT Jug_Celular> > > WHERE jug_codigo < 0020 and> jug_celular<>'
      > ')WHERE> (Jug_Codigo <> 0020)> > > I like update all the> information of my
      > DataBase> of my tableJugador,> > all the> > > telephone of> 8 digits add the
      > 9 to the> begin .> > >> > > for example:> > > 98765412> update to :
      > 998765412 Saludos> coordialmente ROUILLON> SIXTO> > > César> E.Ing. en
      > Informática y> SistemasCel: +51 (01) 80073180Perú> >> > >> [Non-text
      > portions of this> message have been removed]> > >>
      > ------------------------------------> >> Yahoo! Groups Links> > >>>[Non-text
      > portions of this message have been removed]
      >
      > __________________________________________________________
      > Explore the seven wonders of the world
      > http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
      >
      >
      > [Non-text portions of this message have been removed]
      >
      >
      >


      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.