Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Varchar vs char
Message
From
03/11/1999 18:06:34
Michael Levy
Cincinnati, Ohio, United States
 
 
To
03/11/1999 10:45:01
Ken Matson
GCom2 Solutions
Aston, Pennsylvania, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Re: Varchar vs char
Miscellaneous
Thread ID:
00285417
Message ID:
00286549
Views:
20
Ken,

As you found out, SQL Server cannot create an index on an expression.

Your best bet would probably be the varchar witht the hope that not every job title would be 64 bytes long.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform