You don't need to explicity recompile it.

Uh... Don't know about anyone else, but I wouldn't use ISNUMERIC for this... case in point...

SELECT ISNUMERIC('13E5')

SELECT ISNUMERIC('13D5')

SELECT ISNUMERIC('13.5')

SELECT ISNUMERIC('13,5')

SELECT ISNUMERIC('$135')

etc... etc...

Don't need Case if there's always a space (ack... I'm a poet and don't know it)

Actually, not quite true... you can "return [apparently] non-deterministic values" if you trick the heck out of it...

First, create a view that looks something like this...

 CREATE VIEW GetNow

    ...

You must have a really old copy of BOL, Carl   Here's a copy of what BOL says about the decimal data type...

Hey Remi and Anders... nice tag team you guys made!

Ummmm.... You might want to read up on what a "Table Alias" is... it'll make that code look a lot cleaner...

...forgot the divide example... you want THIS kind of crappy accuracy? Tell me which company you're writing this for so I can make sure I...

I sure would like to know why you think MONEY gives incorrect results... 4 decimal places isn't enough?  Maybe not for interest calcs and monthly payment calcs...

But David and...

If the CLR UDF's don't, firing "n" number of queries certainly may... especially when "n" number of queries are calling UDF's... sounds like lots and lots of RBAR (pronounce "ree-bar"...

What kind of error are you getting... you might also post your code so we can help more.  And, don't forget, you must have "SA" privs to use it.

... and, BEST, you need to identify how table A and table B relate to each other... what would the join columns be?

Ummm.... take the ORDER BY out of the view... you should do the order by in procs that reference the view, not in the view itself.

How 'bout the fact that BOL says "OFF" is the default?

Does SQL 2K5 WorkGroup have either BCP or OSQL?  The reason I ask is that the cursor method will take a comparitively very long time... for every line you write to...