SirEvan Posted August 11, 2009 Share Posted August 11, 2009 UPDATE [USMC Data] SET ComputerName = 'Kinser' WHERE CONTAINS (ReaderName, ' "KINSER*" ') I want to update the Column "ComputerName" with the values "Kinser" for every row that contains "KINSER" in the 'ReaderName' Column. I of course will repeat this for various entries, but this is the syntax that I need. Visual Studio is giving me an error with the "CONTAINS" statement when I try to verify the SQL command. Thanks. Link to comment Share on other sites More sharing options...
0 Rohdekill Posted August 11, 2009 Share Posted August 11, 2009 where readername like 'kinser%' Link to comment Share on other sites More sharing options...
0 tsupersonic Posted August 11, 2009 Share Posted August 11, 2009 yep ^ Link to comment Share on other sites More sharing options...
0 SirEvan Posted August 12, 2009 Author Share Posted August 12, 2009 thanks! Was driving me nuts. Link to comment Share on other sites More sharing options...
Question
SirEvan
I want to update the Column "ComputerName" with the values "Kinser" for every row that contains "KINSER" in the 'ReaderName' Column.
I of course will repeat this for various entries, but this is the syntax that I need.
Visual Studio is giving me an error with the "CONTAINS" statement when I try to verify the SQL command.
Thanks.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts