Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Non Case Sensitive Key

Status
Not open for further replies.

JimReiley

MIS
Dec 10, 2004
58
US
How do I modify the sql command below to make the key case-insensitive?

ALTER TABLE adheader IN Dictionary ADD PRIMARY KEY(AdNumber,EntryYear) #

Thanks.
 
Add the CASE keyword:
ALTER TABLE adheader IN Dictionary ADD PRIMARY KEY CASE (AdNumber,EntryYear)
Note, I haven't tried it, but CASE is listed in the SQL Language Reference as a Column Constraint.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top