I have a table with names
UserTable(UserId int, Fullname(varchar(100))
UserId=1, Fullname='John Johnson'
UserID=2, Fullname='Bill William Howard'
I want to select Fullname from the table but not the last name.
From the example above I would like to get the result:
UserId=2, Fullname='Bill William'
Can you please help me with this?