selecting everything left of a :

[nathanharcup]

Hi All,
I am trying to select everything left of a colon ':' in a varchar field, the ':' is not at the same possition so don't think I can use LEFT()

Does anyone have a method I could use

Thanks

Nathan

 

[r937]

left(field,charindex(':',field)-1)

will fail if ':' does not actually exist

r937.com | rudy.ca

 

[nathanharcup]

thanks very much