i used this to retrieve values form a string field where the string has multiple words
1234568 john smith
it retreives the numbers prior to the space
LEFT ({TableName.Field}, InStr({@field}, " "))
if there is only SNAP it returns a blank value
how do i get it to return the vale if there are multiple words or just one?