regarding the sql functions in cognos

[subhash]

hi all,

my database is sql server.

  i want to convert the string value to the numeric value.

i used like this cast('sss') --- giving error.

ex: my string is 'Business data'
  i want to convert that string to the numeric value.

[rockytopmark]

Converting a 'String' to a number is simply not possible, unless the string has numerals in it, like '1234'

If you are trying to convert a Column (query item) that has a numeric value stored as a string, then you can do this but alter your syntax to reference the column:

Cast([QueryItem],<datatype>)