I am trying to
UPDATE [Extract] SET [Type] = 'Main'
If you're trying to do your update to records where
[Name] contains 'Main', you can do it in a simpler way without a
SELECT at all. Use
like() and the
* wildcard. Like this:
UPDATE [Extract] SET [Type] = 'Main' WHERE [Name] like ('*Main*')
* allows for any character string to exist on either side of the string 'Main'.