Filemaker pro show only

[lozdog]

If I do something like this

show (every record whose cell "scene number" = "1c")

I get results for records that have a “scene number” of 1

How do I get it to only show 1c, and ommit every thing else???

I have the same problem with this

delete every request
set theFindRequest to create new request
tell theFindRequest
set cell “scene number” to “1c”
end tell
find

thanks!

[mouramartins]

@lozdog

If I do something like this

show (every record whose cell "scene number" = "1c")

I get results for records that have a “scene number” of 1

How do I get it to only show 1c, and ommit every thing else???

Change the type of field from number to text.