rocky_498 (8/20/2014)
I am sorry, I am lost, would you mind if you help me with expression?
Come on, a little effort please. John has linked to the documentation of substring. Read it from top to bottom, especially the examples.
Then search for the documentation on LEFT and try to find the connection between the two.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP