Skip to Content
0
Former Member
May 21, 2010 at 12:43 PM

instr

32 Views

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?