finding correct word

[Mustafa55]

sorry for my english I hope I can write my problem. for example, There are records in a field.and there are records starting by "B", for example "Book" when I write "B" in field, all records starting by "B" are coming , I dont want like this.ı want a limit searching, When ı write "book" in field than I want the result. How can I do this ?

[Mustafa55]

I solved my problem. I changed type of field. Type of my field was "text" , I changed type of my field as "number"

[LaRetta]

Hi Mustafa55, welcome to FM Forums!!

I cannot understand the results you are looking for so here are a few samples.

If you want to find records that ...

• any words begin with b, try: b
  
• begins with B but ignores records if words beginning with B are not at the beginning, try: ==b*
  
• has the whole word Book anywhere but ignores bookshelf, try: =book
  

You can read up more in your Help (F1) and search for 'finding text and characters'

I am not sure how changing text data to type number will solve your issue.

[Mustafa55]

thank you LaRetta