RE: MySQL versus MS SQL

2004-02-23 Thread HuMPie
I said use NULL otherwise it's make no different (on MS SQL) Best Regards, HuMPie @ Grunn.Org mrtg.grunn.org Dutch mirror of MRTG www.webdns.info Dutch private DNS hoster === Motto: Writing software is more fun than working. ===

RE: 3.23 redhat 9 server install

2004-02-15 Thread HuMPie
Try to download the newer version of mysql, redhat has a newer 1 on his site (or mirrors) Best Regards, HuMPie @ Grunn.Org mrtg.grunn.org Dutch mirror of MRTG www.webdns.info Dutch private DNS hoster === Motto: Writing software is more fun than

RE: Using Wildcards in Query

2004-01-27 Thread HuMPie
Think this is what you seek (sory but its copy-ed out the ms-sql online books :)) This example displays the first initial and last name of each employee, for example, A Fuller: USE Northwind SELECT SUBSTRING(FirstName, 1, 1), LastName FROM Employees Best Regards, HuMPie @ Grunn.Org

RE: wildcards the field

2004-01-27 Thread HuMPie
Select * from table where path like '/data1%' and id='jones' This will serach in table 'table' all the records that match /data1* Best Regards, HuMPie @ Grunn.Org - Disclamer: All you do with the suggestion in this mail is you responsibi