Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how to find last character is int
0 views
Skip to first unread message
Deep
Dec 21, 2009, 5:39:14 AM12/21/09
to
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
Uri Dimant
Dec 21, 2009, 6:33:50 AM12/21/09
to
Deep
Use RIGHT function and take a look at ISNUMERIC function
Use RIGHT function and take a look at ISNUMERIC function
"Deep" <vino...@gmail.com> wrote in message
news:6c578334-cedc-4366...@j4g2000yqe.googlegroups.com...
Deep
Dec 22, 2009, 1:30:25 AM12/22/09
to
On Dec 21, 4:33 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> Deep
> Use RIGHT function and take a look at ISNUMERIC function
>
> "Deep" <vinod...@gmail.com> wrote in message> Deep
> Use RIGHT function and take a look at ISNUMERIC function
>
>
> news:6c578334-cedc-4366...@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
>
>
> - Show quoted text -
Many many thanks
0 new messages