find first space in string (sql)

[Dave Newing]

Hopefully a simple question:
I am trying to return only the left hand charachters in a string before the
first space. In excel I can do this using LEFT(string,FIND(" ",string)-1). I
know I can use LEFT in SQL but is there a similar FIND function??

Thanks

DN

 

[Brian]

Hopefully a simple question:
I am trying to return only the left hand charachters in a string before the
first space. In excel I can do this using LEFT(string,FIND(" ",string)-1). I
know I can use LEFT in SQL but is there a similar FIND function??

Thanks

DN

Assuming we're talking Access here, what you need is to look in help for the
function Instr.

 

[Van T. Dinh]

Left(YourString, InStr(1, YourString, " ") - 1)

should do.

 

[Dave Newing]

I've got it now, thanks to you both!

DN