Evaluating data in a column

• ttsuro@yahoo.co.nz

  Grasshopper

  Points: 23

  More actions

  August 25, 2003 at 3:38 pm

  #159583

  Hi,

  Does anyone know of a way of 'evaluating' the data in a column(field) using the select statement, e.g if I have the string

  getdate() in a particular column of a row, how can i make my select statement return the actual date instead of the string getdate().

  Cheers,

  Tino

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 25, 2003 at 5:08 pm

  #471336

  I think you may be stuck with using a stored procedures that run sp_executesql to evaluate the string.

  An ideal solution would be a function that could use sp_executesql but unfortunately the calling of stored procedures from functions isn't supported.

  Cheers,

  - Mark

  
  Cheers,
  - Mark