>Does anybody know how I can programmatically chop characters off at the first space within a value. For example if the value is Morocco Tops then I want to see Morocco and if the value is Turkish Fabric then it should say Turkish.
>
>Any help would be greatly appreciated

The function at() do what you need.
Ex:
x = "My String"
y = at(" ", x)
z = substr(x,1, y - 1)

or

x = "My String"
z = substr(x, 1, at(" ", x) - 1)

Joaquim