I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname 'space' lastname.
I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function "substring" but since the firstname can be of VARIABLE length, I do not know what to specify in the argument length of the substring function.
Is there any function similar to substring(Name,1,' ') ?
Can you suggest any solution?
April 13, 2005 4:40 PM
April 26, 2005 12:54 AM