> For example, how would I modify this to be case sensetive... > > SELECT q.itemid, g.LocationGroupName, > q.Location, > s.Title, > m.MediaTypeName, m.MediaTypeID > FROM stockquantities q > JOIN stocklocationgroups g ON (q.LocationGroupID = > g.LocationGroupID) > JOIN stockitemdetails s ON (s.ItemID = q.ItemID) > JOIN mediatypes m ON (s.MediaType = > m.MediaTypeID) > WHERE q.Quantity > 0 > AND q.location REGEXP LocationGroupRegex = 0 > > Where the LocationGroupRegex field contains the regex in question.
Never mind, found it... q.location COLLATE latin1_general_cs REGEXP LocationGroupRegex = 0 Thanks for that. -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:197242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
