cancel
Showing results for 
Search instead for 
Did you mean: 

Starts with

Former Member
0 Kudos

HI I have a column that if it starts with 9, 2, or 11 then we want to process.

How to make this in record selection?

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Paul,

Is this a string field?

-Abhlash

Former Member
0 Kudos

it is number

abhilash_kumar
Active Contributor
0 Kudos

If you're reporting against a SQL Query, you're better off converting field to string and extract part of it using substring or other db specific string functions in the where clause.

If you're reporting directly against tables/views, you may add a SQL Expression that extracts part of the number and use that in the selection formula. 

But if you wish to do this in the report's selection formula, it would look like this:

Totext({number field}, '#') LIKE ['9*', '2*', '11*']

-Abhilash