I have some data which looks like so:

```
SourceOfBooking
----------------
Company1 (Foo)
Company2 (Bar)
Company3 (Foo1)
Company4 (Foo2)

```

I am looking to transform this, so my data only displays:

```
SourceOfBooking
----------------
Company1
Company2
Company3
Company4

```

I have tried:

```
LEFT(SourceOfBooking, CHARINDEX(';', SourceOfBooking) )

```

with no luck.

I'm sure I'm missing something incredibly simple... Anyone care to enlighten?

KR, James.