You should be able to use a CASE statement.  Have a look at the example I cooked up below...

CREATE TABLE #test(QuestionNodeTypeUID INT NOT NULL,

       description VARCHAR(50))

INSERT INTO #test (QuestionNodeTypeUID,description) VALUES (5, 'This should END up AS 6') INSERT INTO #test (QuestionNodeTypeUID,description) VALUES (5, 'This should END up AS 6'

Were you using the From database or from file option?  If you choose the from file option, it will work.  Here are the steps..

click from Device, then the elipses...

BackupMedia, Click...

You could create an Access Front end for your SQL server, but when you deploy it you'd want to deploy it as a .ADP, that way  your users can't make...

It seems like youa re on the right track.  Create the new column copy the data using convert and then you'll have to scrub the data for any errors for...

How were you trying to restore the file, via the Gui or Via a script?  If using the GUI there shoudl have been an option to change the location of...

When ever you store a value in a Char() field the database automatically adds the spaces to pad the field to the proper length.  If you are storing values that...

Ken Powers had a decent article abotu the differences of the two back in January...

http://www.sqlservercentral.com/columnists/kpowers/thegocommandandthesemicolonterminator.asp

Hope this helps clear up the difference.

-Luke.

The "best" way is a tricky question.  If it's somethign that needs to be done like yesterday, you'd probably want to stick with the technology that you are most comfortable...

Remember that SQL server is a database and it's main job is to store and retrieve data.  Access on the other hand is both a database (Stores and Retrieves data),...

I finally received my Daily newsletter from the 22nd late like at 2300 on the 22nd.  I never recieved Friday's or Monday's emails, but I did receive the Database Daily...

I personally like the idea od a lookup table that supplies this info to you.  More importantly however I think you need to think about perhaps using a store procedure...

I'm still slightly confused as to why you need EM to execute the DTS package, but oh well... Can you tell me what kind of permissions you are giving them? ...

I beleive that may be part of the problem.  When you are creating that connection and the DTS package is running from the server it thinks you want to write...

What does the Dynamic Properties Task change?

Have a look at the following article http://www.sqldts.com/default.aspx?208.  I think it may help with your issue.  I think you need to make sure that a) you make all of the...