no column name for column where CAST has been used

• Robert Morgan

  Mr or Mrs. 500

  Points: 527

  More actions

  January 2, 2007 at 8:48 pm

  #171661

  following query works but result set shows [no column name ] for cast(request as varchar(200)) field. How can I alias this field?

  using cast(request as varchar(200))as request does not work.

  select title,firstname,surname,required_date,address1,birth_date, cast(request as varchar(200)) ,home_phone,req_id,

  user_name,event_number,acc_number,nhi, count(*) as total from vrequest

  where req_id = '324'

  group by title,firstname,surname,required_date,address1,birth_date,cast(request as varchar(200)),

  home_phone,req_id,user_name,event_number,acc_number,nhi

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  January 2, 2007 at 8:51 pm

  #680890

  cast(request as varchar(200)) as 'Some Alias'