In answer to Phil's question,

I just moved from Missouri to Georgia (both USA) a month ago to launch my IT career with a small software company. I'm a developer...

Just chimming in...

Thanks Phil. I'm in a similar situation. New job, but only a non-poisonous-snakepit (I hope).

Looking for best practices from a developer's perspective. To much code to write & not...

One more thing...

The article Frank recommended is just the ki8nd of thing I'm always looking for. If anyone has any other aritcles to recommend that cover a topic thoroughly, I...

T H A N K    Y O U    S O    M U C H   !   !   !

I am so relieved to finally have this working. What amazes me though, is that if...

I really appreciate the advice about NVARCHAR (which I picked up from examples on BooksOnline, and figured if they did it, it must be a good idea. Wrong.)

But as far...

Yes, I've been using BooksOnline constantly for the past few weeks. It's a great help, but the examples often leave something to be desired.

Thanks a bunch, you guys. I really appreciate the tips. I'm going to buy the recommended books as soon as I get paid.

Muchos Gracias,

Gregorio

Strange, I posted a reply, where did it go? Here goes again...

**********************************************************

Wow, that's exactly the kind of information I'm looking for. I didn't know a CASE statament could be used...

I tried it your way, and all I get is the following error:

Could not find stored procedure 'UPDATE SYSOENT

                       SET CREDIT_CARD_# = dbo.udf_smearcc(@column),

                       WHERE order_no < 100'.

I did it like you said....

Hey Mark,

Yes, that helps a lot! I really appreciate the info. Is there anything I need to click on to give you a vote, or to otherwise show gratitude? I...