• 0

[SQL] Fix this SQL statement


Question

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

3 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.