Select records based on field value

[dbr4444]

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"

 

[peterbruce]

What help do you need? You haven't actually asked for anything.

 

[Lucky.2811]

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]

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.