Return String up to space

[apug]

I have a table with a [user] column. The format is UserName - NTLogin. I need to run a query that only returns the UserName up to the space. UserName is of varying string lengths.

 

[Golom]

Select Left([User], Instr(1,[User]," ")-1) As [UserName],

 

[apug]

Golom This worked great. Thank you. I haven't seen this before. What is the "Instr" function?

 

[rjoubert]

http://www.w3schools.com/vbscript/func_instr.asp