SQL switch firstname and lastname

Question

Hello. I am Sorry for question but I am stuck. How can I switch row where is lastname and first name = 'Ware, John' to get fullname without comma 'John Ware' ? Thank you very much

Answer 1

Break this into smaller problems. First problem is you need a way to identify where the comma is. If you can get the index of that you can break up the string with substring and concat the pieces together. Remember that the comma will not always have the same index in the string. Hope this helps!

Answer 2

Thank you for hint. Can I use
STRING. SPLIT()
for this?