Skip to Main Content

Search Medical Databases Using Wild Cards ($), Truncation (*) & Phrase Searching (): Database Utilization of these Tools

There are various ways to search a databases and for most databases, what you put into it will be what you pull back. It is very important to use resources that will expand your search & make it more exact.

Database Truncation, Wildcards & Phrase Searching

Different databases use a range of truncation and wildcard symbols and phrase searching features. In an effort to minimize looking up which databases do what, below I’ve created tables that will show which databases use which symbols and in what capacity.

Click on Databases to find truncation, wildcards and phrase searches are applicable: 

Clinical Key

Cochrane

EBSCOhost Databases

Embase

Gale Databases

JSTOR

LexisNexis 

NewsBank Newspapers

OVID Databases

Project MUSE

ProQuest Databases

PubMed

Sage Databases

Science Direct

Scopus

TRIP Database

Web of Science Databases

Wiley Online

Clinical Key

Database/Platform

Truncation

Wildcard

Phrase Searching

Clinical Key

Not Available

Not Available

Phrase search is supported only for one entire search phrase. No Boolean operators are supported. Enclose phrases in double quotes.

Cochrane Library

Database/Platform

Truncation

Wildcard

Phrase Searching

Cochrane Library

*

?

Enclose phrases in double quotes.

 

EBSCOhost

Database/Platform

Truncation

Wildcard

Phrase Searching

EBSCOhost

Abstracts in Social Gerontology

Academic Search Complete

AGRICOLA

Alt Health Watch

American Doctoral Dissertations

PsycArticles

Business Source Complete

CINAHL

ERIC

Family Studies Abstracts

Global Health

GreenFile

Health Source: Nursing/Academic

MEDLINE Complete

Political Science Complete

PsycArticle

Psychology and Behavioral Science

PsycINFO

Social Work Abstracts

Social Work Reference Center

SocIndex

SportDiscus

*

? represents 1 character

# represents zero or one character

Enclose phrases in double quotes.

Embase

Database/Platform

Truncation

Wildcard

Phrase Searching

Embase

*

? represents 1 character

# represents zero or one character

Enclose phrases in single quotes.

 

Gale Databases

Database/Platform

Truncation

Wildcard

Phrase Searching

Gale Databases

Health Reference Center Academic

Nursing & Allied Health Collection

Academic One File

Opposing View Points

*

? represents 1 character

?? represents

2 characters

! represents 0 or 1 character

Enclose phrases in double quotes.

JSTOR

Database/Platform

Truncation

Wildcard

Phrase Searching

JSTOR

*

?

Enclose phrases in double quotes.

 

LexisNexis

Database/Platform

Truncation

Wildcard

Phrase Searching

LexisNexis

!

*

Two or more words default to a phrase

 

NewsBank Newspapers

Database/Platform

Truncation

Wildcard

Phrase Searching

NewsBank Newspapers

*

? represents 1 character

?? represents 2 or more characters

Enclose phrases in double quotes.

 

Ovid

Database/Platform

Truncation

Wildcard

Phrase Searching

OvidSP (Advanced Search Only)

Joanna Briggs Institute

Nursing @ Ovid

Ovid MEDLINE

Social Work Abstracts

* or $

# represents 1 letter or number

? represents 0 or 1 letter/number

Two or more words default to a phrase

 

Project MUSE

Database/Platform

Truncation

Wildcard

Phrase Searching

Project MUSE

*

Not Available

Enclose phrases in double quotes.

 

ProQuest Databases

Database/Platform

Truncation

Wildcard

Phrase Searching

ProQuest

Communication Sciences & Disorders

Government Periodicals Index

Nursing & Allied Health

Physical Education Index

Physical Therapy & Sports Media

Social Services Abstracts

*

? represents 1 character

?? represents 2 or more characters

Enclose phrases in double quotes.

 

PubMed

Database/Platform

Truncation

Wildcard

Phrase Searching

PubMed

*

Not Available

Enclose phrases in double quotes.

 

Sage

Database/Platform

Truncation

Wildcard

Phrase Searching

Sage

Sage Premier

Sage Research Methods

*

?

Two or more words default to a phrase

 

ScienceDirect

Database/Platform

Truncation

Wildcard

Phrase Searching

ScienceDirect

*

?

Enclose phrases in double quotes.

 

Scopus

Database/Platform

Truncation

Wildcard

Phrase Searching

Scopus

*

?

() braces or brackets for exact phrase. Enclose phrases in double quotes for adjacent terms, but not necessarily in an exact phrase.

TRIP Database

Database/Platform

Truncation

Wildcard

Phrase Searching

TRIP Database

Not available

Not Available

Enclose phrases in double quotes.

 

Web of Science Databases

Database/Platform

Truncation

Wildcard

Phrase Searching

Web of Science

BIOSIS Citation Index

Current Contents Connect

Data Citation Index

Derwent Innovations Index

KCI-Korean Journal Database

MEDLINe

Russian Science Citation Index

SciELO Citation Index

Zoological Record

*

? represents 1 character

$ represents 0 or 1 character

Enclose phrases in double quotes.

 

Wiley Online

Database/Platform

Truncation

Wildcard

Phrase Searching

Wiley Online

*

*

? represents 1 character

Enclose phrases in double quotes.