Prev: occurence of charcter no of times
Next: alternating column color in matrix
From: Deep on 21 Dec 2009 05:39
Dear Sir/Madam,

How can I know that last character of string is integer of any field.
If it is possible in one select command then it is better.

For eg. in table register_tbl
DelegateNo
'TK-INV-88-CC'
'TK-INV-89'

Second delegate no has last character is integer, How can I find all
row which last character of delegateno is integer

Thanks in advance
From: Uri Dimant on 21 Dec 2009 06:33
Deep
Use RIGHT function and take a look at ISNUMERIC function


"Deep" <vinodkus(a)gmail.com> wrote in message
news:6c578334-cedc-4366-99c3-247cd2383fc5(a)j4g2000yqe.googlegroups.com...
> Dear Sir/Madam,
>
> How can I know that last character of string is integer of any field.
> If it is possible in one select command then it is better.
>
> For eg. in table register_tbl
> DelegateNo
> 'TK-INV-88-CC'
> 'TK-INV-89'
>
> Second delegate no has last character is integer, How can I find all
> row which last character of delegateno is integer
>
> Thanks in advance


From: Deep on 22 Dec 2009 01:30
On Dec 21, 4:33 pm, "Uri Dimant" <u...(a)iscar.co.il> wrote:
> Deep
> Use RIGHT function and take a look at ISNUMERIC function
>
> "Deep" <vinod...(a)gmail.com> wrote in message
>
> news:6c578334-cedc-4366-99c3-247cd2383fc5(a)j4g2000yqe.googlegroups.com...
>
>
>
> > Dear Sir/Madam,
>
> > How can I know that last character of string is integer of any field.
> > If it is possible in one select command then it is better.
>
> > For eg. in table register_tbl
> >  DelegateNo
> >  'TK-INV-88-CC'
> >  'TK-INV-89'
>
> > Second delegate no has last character is integer, How can I find all
> > row which last character of delegateno is integer
>
> > Thanks in advance- Hide quoted text -
>
> - Show quoted text -

Many many thanks
 | 
Pages: 1
Prev: occurence of charcter no of times
Next: alternating column color in matrix