• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Select records based on field value

dbr4444

Member
I have a table that holds a string value in one of the fields. If the string held in that field starts with "ARE" it will populate a report variable with that string.

The problem is there are multiple records that have the same info. I only want to select the record if the specific value in the string begins with "ARE" I am using the BSFN "IsStringInString" in order to identify if the string starts with "ARE"
 

Lucky.2811

Active Member
You can compare first three letters from the string and can check if that is "ARE" using substring. Refer sample code.

Result=Substring (String Field,0,3)
If Result=ARE
{
Process
}
 

alfredorz

Well Known Member
If you are doing select or fetch next to table, you can use LIKE conditional. Else if you use Business View as said Lucky.2811 you can doing substring for the 3 first letters and compare with "ARE"

Regards.
 
Top