Hello I am trying to query from VB.Net, but were I pull my data it gives me full name including lastname, firstname and middle name.
I would like to remove everthing after 2nd white space example
String Sampson, Robert Steve should just be Sampson, Robert
String Sahdala, Lesbia P should just be Sahdala, Lesbia
It seems like something I should be able to do with trim command. It seems like a simple thing but can't seem to figure out Syntax.
Anyone have any ideas or maybe maybe have another way