> -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 29, 2002 1:06 PM > To: CF-Talk > Subject: OT: SQL question
<snippage> > The part before the dot is all I want to use to compare to the other table > which will only contain the first part. It would be something like this. > > 12345.123 = 12345 > 12345.234 = 12345 > 12345.654 = 12345 > 02nt911dc.123 = 02nt911dc > 02nt911dc.054 = 02nt911dc > 02thq5 = 02thq5 > 02thq7 = 02thq7 > > How would I do that using just sql statements? I would imagine you could use a like statement ... WHERE '12345.123' LIKE '12345' + '.%' or rather WHERE table1.partnumber LIKE table2.partnumber + '.%' Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
