Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
Can wildcards be used when searching?
Can wildcards be used when searching?
Can wildcards be used when searching?
If the search is for Contains, Starts With, Ends With, or Like then some wildcards are supported:
Wildcard
Description
Example
%
Matches 0 or more characters
John% matches John, Johnson, Johnathan.
_
Matches any single character
A__a matches Alma, Alva, Anna
[abc]
Matches any character in the list
[adl][aen]na matches Anna, Dana, Lena
[a-c]
Matches any character in the range.
Note
: 0 is considered to come after the number 9. To get a range of 0-5 you would use [01-5].
[a-cy-z]% matches everything that starts with A, B, C, X, Y, or Z.
Wild cards can be mixed and matched:
[4-7]-1% matches anything that starts with 4, 5, 6, or 7 followed by a hyphen and 1 then any number of characters. Depending on your account number setup, this type of search might find all Revenue and Expense accounts for your upper school.
[q-twzf-h]___ matches a 4 letter word that starts with F, G, H, Q, R, S, T, W, or Z. Notice how you can have a mix of ranges and single characters within the same brackets.
When might you use wild cards?
- Accounting can use wildcards to match all accounts.
Example
: If you have a 6 digit account number, _3_5__ would find all accounts where the second digit is 3 and the 4th digit is 5.
- Searching for names where you don’t know the correct spelling.
Example
: You don’t know if the name is spelled Johnson, Jahnson, Jonson, Jonnson, or some other obscure spelling. But you do know that it starts with a J and ends with son: J%son
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.