Should be straight forward, but I keep getting this error
shipping_status is not a recognized function name
And this is my syntax - what is causing this, as my statement will run issue free in SSMS
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.Connection=New-Object System.Data.SqlClient.SqlConnection
$SqlCmd.Connection.ConnectionString='Server=Server1;Database=DB1;Integrated Security=True'
$SqlCmd.Connection.Open()
$SqlCmd.CommandText="UPDATE firefly.light.dbo.shipped SET shipped = 'Yes' WHERE shipping_status IN ('Loading', 'Shipped') "
$SqlCmd.ExecuteNonQuery()
Your code looks fine to me but maybe try escaping the single quotes with a grave-accent(`):
etc