If you mean round to the nearest whole number, then simply converting to INT will do...

DECLARE @Amount1 MONEY

    SET @Amount1 = 7.49

DECLARE @Amount2 MONEY

    SET @Amount2 = 7.50

DECLARE...

You bet... Merry Christmas.

You are new at this...

Try this, Josh...

   UPDATE yourtable

      SET Name = RTRIM(SUBSTRING(Subject,1,CHARINDEX('#',Subject,1)-1)),

          Paid = RTRIM(SUBSTRING(Subject,CHARINDEX('#',Subject,1),

                                         CHARINDEX('$',Subject,1)-CHARINDEX('#',Subject,1))),

        Amount = RTRIM(SUBSTRING(Subject,CHARINDEX('$',Subject,1),

                                         CHARINDEX('/',Subject,1)-CHARINDEX('$',Subject,1))),

       CheckNo = RTRIM(SUBSTRING(Subject,CHARINDEX('/',Subject,1)+1,999))

     FROM yourtable

And, let's hope...

I'm thinking... REFRESH, REFRESH, REFRESH again.

Assuming that the column you are parsing is called "ParseThis" and your table name is called "yourtable", this will work PROVIDED that you always have all 4 parts...

 SELECT...

No, but I'm thinking that this is "Death by SQL" of the same magnitude as disabling the automatic recalculation of statistics.

"Books Online" describes both FLOAT and REAL as follows:

"Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data...

If your job only runs on Saturday, then you've done it the most efficient way.

Carl, sometimes there's just no application to be had... SQL is it.

Mark, the reason you are getting the error is that you must either have SA permissions or your DBA...

Very cool, jratwork... I have a similar un-natural aversion to correlated subqueries and I had my doubts when I saw the "<" in the correlated subquery... but I just ran...

First, this isn't a DB2 forum and not all SQL's are created equal.  That, notwithstanding, you say "it didn't work"... if you got an error message, is sure would be...

"Online AnonProfile" seems a bit paranoid as a "handle" to me ... whatever...

This little ditty should help you in your quest for primary...

You can't do this with a constraint... you'll need to use a trigger or, maybe, you can also try a "calculated column".

Can you run the following?

EXEC Master.dbo.xp_CmdShell 'Dir C:\'

If not, your SYSADMIN got the "religion of security" and disabled access to xp_CmdShell.

I'm thinking that's part of the reason he wanted to put it in the Master database although, I agree, putting it in the master is not a good idea.  It...