Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display only names with the first letter C?

 

Below is a table with Patient Last Name and all that is in the syntax is PatLName.

 

Find out how we can only display in the table something based on criteria, For example how do I only display a list of names that start with the letter “C”.

 

 

 

1 Solution

Accepted Solutions
sunny_talwar

May be like this

If(Left(PatLName, 1) = 'C', PatLName)

View solution in original post

2 Replies
sunny_talwar

May be like this

If(Left(PatLName, 1) = 'C', PatLName)

Not applicable
Author

thank you, I really appreciate the help.