I have a legacy system that uses a strange date format, wich I'd like to
convert for datetime on a new table.
The date is in this format: 104001(2004-01-01), 104002(2004-01-02),
104271(2004-09-27)

but it is not working for whole number like ex:11120
it is fetching it as 11120.  (with point at the end)
how to do that.
thanks,

hi Steve,
 Thanks for that.  it is working fine.
But for the whole numbers like 123456 it is not doing so.
it is formatting to 1,234,567.00 (with two zeroes after

I have a field that is made up of several important values
all in one string. (Location.Serial# + '-' + ID). I need
help seperating this field in a query. I can use Substring
to take everything to the right of the '-'. Can anyone

Not sure if this is the right forum, if not, please
direct me.
When I create a link to a SQL 2000 server database via
Dreamweaver MX, for some reason on one account retrieved,

The following error message when you execute queries in
the Query Designes throuht SQL-Server Entreprise Manager
(SEM):
The query cannot be executed because some files are either

i've just realized i've installed my mssql to be case-insensitive, now all
my queries seems to be case insensitive.
Is there any workaround?? How should i write my sql statements to be case
sensitive now??? because i get the same results for:

  i have a sql table field price and datatype is
decimal 13(20,6).
 when i insert values to this field, values are being
inserted correctly. i.e. 13.45 inserted as 13.45 and

I've problem to check row which having duplicate value
for fieldA and fieldC.
Eg.
rec 1

 I have requirement.
 I want to format a numeric value with commas. is there
any function to use in transact-sql query to do this.
for example if the numeric value is 27519.37 then it

When running the following query and subquery with a NOT
IN clause, I'm getting no results with SQL Server 2000
SP3.  Has anyone seen this before ?
=======================================  

I import text file into SQL table, one column
name 'date', datatype is varchar and string in field
like 'dd/mm/yy'. I want to convert varchar into
smalldatetime and output is 101 'mm/dd/yyyy'. my query is:

How to convert character string to numeric? Thanks!

I wish to include a condition in my order by statement.
i.e. If the value of Field X > Y then Order by Field X,
else Order by Field Z.
I have tried inserting a select case but i cannot get it

i am new in mssql7.Using sp_password i put login password
for the server.How can i put a password for a particular
database in the server.
Thank you.