difference between FindFirst findset and find function

hi sir

please tell me in which condition we can use these function.

Please check these links to understand the difference

To sum it up, Findfirst fetches the first record from the table, whereas, Findset fetches a set of records from the table.

Both the functions are used based on requirement. Using the correct function at the correct place matters a lot. This helps the code to remain optimized.

Check this out



If you are not sure what to use, then always use FIND(’-’) as this is always the safest. Only use FINDFIRST and FINDSET if you understand why you are using them. FINDFIRST and FINDSET were introduced to improve performance, but can actually slow down the code if used incorrectly.

Hi [mention:facd1c39e088429db490237bf8d2779f:e9ed411860ed4f2ba0265705b8793d05] , I have a question.
Does FIND(’-’) applies the required condition automatically? How does it work.

Thanks for sharing the thought, I wasn’t aware of the fact that we can use (’-’) instead of first or set with find when we aren’t sure what to use.