Why dont we break it down on an average:

1200rent

400groceries

300gas car

100ins car

200eletric

100gas

300health ins

300car payment

2900total monthly cost

34800total year cost

44544with tax cost tossed in

So on an Average to live in america you need...

Success

observation

JohnDBA

The easiest thing for you to do is correct the design failure something like this:

alter table #MySample add addessCode varchar(18)

Then update it with the proper values, after that make...

JohnDBA

froget the address table and look at the mysample table. You have 2 records that have that value. Once again how do you know that the record belong to ZZ...There...

Nevyn : Thank you for noticing.:-D

So how can I determine that based on the info you gave me? There is nothing in the #MySample table letting me know that row belongs to ZZ group.

JohnDBA

I must join ID with address code where code start with 'A B ' + 9 digits.

There are 3 spaces between A and B, and there is 1 space after...

$50K...

absurd

John

did you try my suggestion no reverse at all:

SELECT * FROM #MyAddress a join #mysample s on

Right(replace(a.AddressCode,' ',''),9) = LEFT(s.ID,9)

where replace(a.AddressCode,' ','') like ('AB%')

So true Jeff thats why I stated not sure what he...

JohnDBA

I think this is what you wanted:

SELECT * FROM #MyAddress a join #mysample s on

Right(replace(a.AddressCode,' ',''),9) = LEFT(s.ID,9)

where replace(a.AddressCode,' ','') like ('AB%')

bitbucket-25253

LOL!!:hehe:

JohnDBA

I must join ID with address code where code start with 'A B ' + 9 digits.

There are 3 spaces between A and B, and there is 1 space after...