How can I select all the default values that start with the character 'A'?

Solution 1:

Assuming your parameter dataset query for the available values is the following

SELECT Value_Field, Label_Field
FROM mytable

You have to create a second dataset with the filter and set it as your parameter default values

SELECT Value_Field, Label_Field
FROM mytable
WHERE Label_Field LIKE 'A%'

enter image description here