I have a table named conversion. In this table there is not a field for "first name", but only a field for "last name" and "Contact Name". The "Contact Name" holds the full name (First and Last), and the "Last Name" holds the last name.
In theory I was thinking that I could take the "Last Name" field and subtract the amount of characters + 1 additional (to account for space in between Contact Name Field - FirstName LastName) and then I would have the first name?
I can find the amount of characters in a field name by using this:
SELECT LEN(lastname_column) AS 'Length', lastname_column
I think you'll find that name strings are messier than that, and there aren't any simple rules that will reliably parse them.
Try running this script to create a function on your database that you can call to parse out any part of a name string:
If it's not practically useful, then it's practically useless.