ASP query expression

[Marco Alting]

Hi,

is it possible to have a replace() function in an SQL query? I need to use
something like that to be able to sort my "sequential-numbers", which are
actually textfields like this:

98.1
98.10
98.2
98.3
98.4

What I want is to query these numbers, convert them by removing the dot with
the replace command and the sort the recordset on it.

Is this possible?


Thanks,
Marco

 

[Bob Barrows]

Hi,

is it possible to have a replace() function in an SQL query? I need
to use something like that to be able to sort my
"sequential-numbers", which are actually textfields like this:

98.1
98.10
98.2
98.3
98.4

What I want is to query these numbers, convert them by removing the
dot with the replace command and the sort the recordset on it.

Is this possible?


Thanks,
Marco

REPLACE is a T-SQL builtin function, so if you are using SQL Server, you
are all set. Of course, if the data is stored in a numeric column, then you
will need to cast the data to varchar before using REPLACE.

If not SQL Server, perhaps you would like to let us know what database you
are using ... ?

Bob Barrows