u r joking aint you...

There is nothing to get confused Mr Rehman...just copy paste the code before your post and you will know exactly what it does. By the way the issue is now...

Good Morning...

DECLARE @abc TABLE

(

SerialNumber varchar (50)

)

insert into @abc (SerialNumber)values ('00132 0045749WSE1')

insert into @abc (SerialNumber)values ('00181 ...

thank you very much Sir!

Ok i analysed the data and got a clue

create table abc

(

SerialNumber varchar (50)

)

insert into abc (SerialNumber)values ('12345 0047225P1')

insert into abc (SerialNumber)values ('00011 0055500ABC2')

So basically there is the letter to choose...

Thanks for your replies

i am looking for something like this

DECLARE @STR VARCHAR(100)

SET @STR = '12345 0047225P1'

SELECT SUBSTRING(@Str,CHARINDEX(' ',@Str)+8,1) + ' '+...

create table abc

(

SerialNumber varchar (50)

)

insert into abc (SerialNumber)values ('12345 0047225P1')

insert into abc (SerialNumber)values ('00011 0055500ABC')

I am expecting a table with once column name account number and the result like

Account...

so basically i need a query to fetch serial number and letter from the column which has two type of data

12345 0047225P1

00011 0055500ABC

The first data should have...

Hello Good Morning...Some of the data is like

00011 0055500ABC

So in this Account Number should be 0055500 and Account Letter should be only C

I will test and let you know ... Thanks

cheers mate!

its cool i sorted it

sorted

cool. Thanks mate.

yeah thats what i was thinking as well.. Thanks.

Or may be i will have sql job which will transfer the data into a table in a database. What do...