Just for giggles, I'd still like to know what the SN columns are for... what are they?

Crud, you're right, my bad...Thanks, Michaeal.   Except should be this because, as you said, Peter's algo returns +/- 5...

UPDATE ValueDetails

    SET AVM = AVMValue * (1+(ABS(CHECKSUM(NEWID()))%11-5)*.01)

I'm thinking that I'd follow Mark's suggestion about staying away from BCP and xp_CmdShell for a Web app... too many complications... too many security risks.

I'd be tempted to write something...

Thanks for the great feedback Georgio and Carlos.

Do look at Serqiy's post, again... as he says, these types of tables provide for some great flexibility, but at a potentially serious...

If the names aren't supposed to mean anything to do with the database, I think you're on the right track... of course, you could also name them DB0001, DB0002,... etc. ...

Post the SQL that you would use to select the data to export, please... no conversions, no CSV attempts... just the query to select the data you want to export...

Ok... I made a spreadsheet that looked like this...

col3

Ok... you've got a good example... just change it

LOL... yeup... been in that same spot once or twice myself.  Anyway, thanks for getting back to me.

Heh... I was trying to think of a way to prove some of the bad experiences I've had with some programmers using UDF's for everything... then I checked my email...

I've not had to work with Accent words so I'm not 100% sure... if I remember correctly, though, take a look at "Collation" in Books Online... seems like I remember...

Not to worry...  considering the situation you said you're in, I absolutely don't blame you especially in the absence of anything else in my rather one-sided first post.  I'm in...

Ok, folks... I don't get it... why does everyone keep adding when they should be multiplying???    Using Peter's modified algo which returns .95...

I just make sure I do a copy of everything in the reply window before I hit submit... I learned that "posting" lesson on this and other forums... kinda like...