ok Joe no worries

Could you tel lme what SSMS is

Thanks

Alan

Ok Lynn if thats what you want to do and move on and help someone else then thats fine.

I am new to SqlServer so I dont know how to do...

Sorry Lynn

The BigTable.software_name_raw contains

SOFTWARE_NAME_RAW

Microsoft Office 2003 Professional Edition, Office 2003 Professional

Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional

Microsoft 2003 Office Professional, Office 2003 Professional

and the RefTable contains a further...

Hi Brad.

The software_name_raw on the RefTable is the Primary Key

Does that help

hi guys sorry for the confusion, all i want to do is concentrate on the first 3 columns

so if the data shows this

Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,bla

Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,different bla

Sun Microsystems, Version...

I figured out why it was because of the data I was importing.

I have used that query thank you very much for your assistance

ok guys I think I best show you the full query to see where I am going wrong. OH bare in mind some of the values in the columns have...

ok guys I have gone with the case statement it seems to be working but I am getting quite a few columns with the value

unknown.x in it even the the...

thanks guys thats very helpful, just one thing, the second query you provided how does that cover anything else just to provide the original value

dwain

fantastic that seems to work fine, will that also cover any null values

much appreciated

alan

my next post is going to be on a bulk insert I am having a problem with...

ok uys, firstly thanks for your prompt response I have noticed one error in that I am not trying to update with the software name amended when i should be

secondly...