🚀 go-pugleaf

Small answers to small questions: =)

1. If you are using MSSQL, you should set sort order to dictionary,
case-insensitive. If you have already set up the databases, be forewarned.
You must rebuild the Master database which in effect, rendering other
databases useless. You may opt to use string conversion techniques (upper,
lower etc.) to fetch the data you like.

2. You can actually do this with the Identity field, in which case, the
table behaves much like flat-file database.

3.  You may want to check these sites:

- Introduction to Structured Query Language at
http://w3.one.net/~jhoffman/sqltut.htm
- www.mcp.com. Look under On-Line Books. The last time I visited the site, I
saw Using MS SQL Server 6.5.

Hope this helps.


Mark Zulueta
PrimeSoft Ventures