I have a path like below in one of the column " /ACCOUNT 9 Production Record/RHB Unit - Consumer" so I want this value when I select to be view as " /ACCOUNT 9 Production Record/Unit - Consumer"
so I try with following t-sql below
where Name like '%Account_I%'
anyhow this not work and return me with error below , any suggestion how to correct this syntax?
Msg 156, Level 15, State 1, Line 17
Incorrect syntax near the keyword 'from'.