Mark,
Look at the SQL Server commands CONVERT() and CAST()
From books on line:
CAST and CONVERT (T-SQL)
Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.
Syntax
Using CAST:CAST
(expression AS
data_type)Using CONVERT:CONVERT
(data_type[
(length)],
expression [,
style])
Cheers,
Andrew
>HI all.
>
>i couldn't find how to convert string (varchar) values to numeric in sql server? any ideas.
>
>thanks in adavnace - Mark.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.