Question

• huilinglee

  SSC Enthusiast

  Points: 146

  More actions

  December 30, 2003 at 11:02 pm

  #83624

  how do i do the query for this?

  queries the name of the employee and indicates the ammounts of their salaries through astericks. Each asterick signifies $100. and both of this should be in a column.

  table = emp

  employee name= ename

  salaries = sal

  -> I don't know how to set an asterick to a hundred dollars. and should I concat it for it to be in one column?

  Thanks in advance.

  ling

  eat when you can and not when you cannot.

  
  eat when you can and not when you cannot.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  December 31, 2003 at 5:34 am

  #488335

  Try something like:

  select ename, replicate('*', isnull((convert(int, sal) / 100),0)) from emp

  Cheers,

  - Mark

  
  Cheers,
  - Mark