reference column name

[thesti]

hi,

how to reference an alias column name that consists more than one word.

it's like this

select address, substring(address, 5, 8) as 'member's address' from msmember
where charindex('r', substring( alias column name, 1, 6))>0

i want to check if the first 6 chars of 'member's address' contains 'r'.


thx.

[ck9663]

hi,

how to reference an alias column name that consists more than one word.

it's like this

select address, substring(address, 5, 8) as 'member's address' from msmember
where charindex('r', substring( alias column name, 1, 6))>0

i want to check if the first 6 chars of 'member's address' contains 'r'.


thx.

I don't think you're allowed to have quote in a column alias.

Try this instead:

select address, substring(address,5,8) as [member address] from msmember where charindex('r', left(address,6)) > 0
 

Watch out for space on the left side of the address field.

-- CK