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.
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>)