find characters

[adi32]

i have a text field with "W XX" inside (XX=number)
ex "W 32 sbiuisd"
"W 25 isjoisjos"
"hihiqhw W 31 sbiqweuisd"
i want to have a querry that returns only the "W XX"

 

[JimmyS]

try

mid("W", 1, 4)

something like that?

**ok - just realised that won't help with any fields with another "w" in, sorry**

 

[neileg]

Providing the W in "W XX" is always uppercase and W never appears in uppercase anywhere else in the field, the following will work:

Mid([TextField],InStr(1,[TextField],"W",0),4)

where TextField is the name of the field holding the text string.

 

[adi32]

Thank You Very Much