urgent please

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Based solely on your post the following code works:

create table #TestTable(

vai1 int,

vai2 varchar(50)

);

insert into #TestTable

select 1,'1234,578';

select

right(vai2, len(vai2) - charindex(',',vai2))

from

#TestTable

where

vai1 = 1;

drop table #TestTable;

Next question, what are you trying to accomplish and is the data you posted reflective of all your data?

venkatesh.kuppili Mr or Mrs. 500 Points: 579 More actions · Answer 2

i got the expected result by following query...

select substring(vai2,charindex(',',vai2)+1,len(vai2)- convert(int,(charindex(',',vai2)))) from testvai where vai1=2

is ther any simpler way..

Please help me..

venkatesh.kuppili Mr or Mrs. 500 Points: 579 More actions · Answer 3

THank you very much..

i got the same result in a simpler way..

select right(vai2, len(vai2) - charindex(',',vai2)) from testvai where vai1=2

Thankq for the quick reply..

ps. One Orange Chip Points: 29422 More actions · Answer 4

declare @str1 varchar(10)

set @str1='1234,578'

select right(@str1,len(@str1)-charindex(',',@str1))

output

----------

578

(1 row(s) affected)

Pradeep Singh

ps. One Orange Chip Points: 29422 More actions · Answer 5

One Orange Chip

Points: 29422

January 20, 2009 at 11:23 am

i was so slow!!

Pradeep Singh