I have this and it is an Access Query:
iif(Left([companyName],4)="The ",mid([companyName],4) & ", The",[companyName])
What it does is looks for a name that starts with "The" it takes it out from the front and puts it at the end so:
The Book Store
Book Store The
I need to use TSQL to do the same thing and need help writing the proper syntax for TSQL which will be an update to the table.
Please help and thanks....