asked on 9/4/2013

query modification

I am running the following script, I need to express the b.account code result

180012003110050, I need to show 100 in its own column, the 100 is 5 to the left at the end of the b.account result, how do you express that in the query below and put the 100 result in a separate column?

I have attached the query
query.txt

Microsoft SQL Server Microsoft SQL Server 2008

Last Comment

Amanda Walshaw

9/4/2013

SOLUTION

Jim Horn

9/4/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

ASKER CERTIFIED SOLUTION

plusone3055

9/4/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

plusone3055

9/4/2013

jimhorn
I think he just wants the substring of that number

Jim Horn

9/4/2013

Let's let the OP define his own requirements.

plusone3055

9/4/2013

of course
I was just taking a guess :)

quite an impressive resume btw

Jim Horn

9/4/2013

Thanks.

I'm not trying to dog you, but I notice a lot of questions where the asker either doesn't understand their own requirements, or doesn't state them fully / clearly in the question, so I've found it useful to flush it out of 'em first.

plusone3055

9/4/2013

wasn't even thinking that
no worries. It's all about lending a hand to the poster

Amanda Walshaw

9/4/2013

ASKER

correct substring syntax was required thanks.