so will MID all by itself :-) > Instr and mid combo will though. > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Community" <[EMAIL PROTECTED]> > Sent: Monday, August 12, 2002 8:17 AM > Subject: Re: Semi OT: M$ Access Equivalent to SQL Server Substring function > > > > InStr will tell you whether a substring is contained > > within a string, and where it starts. It doesn't > > actually return the string, just a number with its > > position... > > > > > Instring I believe. > > > ----- Original Message ----- > > > From: "Larry Lyons" <[EMAIL PROTECTED]> > > > To: "CF-Community" <[EMAIL PROTECTED]> > > > Sent: Monday, August 12, 2002 7:05 AM > > > Subject: Semi OT: M$ Access Equivalent to SQL Server Substring function > > > > > > > > > > Sorry about the OT, but I'm setting up one of our apps that formerly > used > > > > SQL Server, but now has to use M$ Access. Is there an equivalent in > Access > > > > to the SubString command, as in SUBSTRING(AW.SKU, 5, 2) for instance? > > > > > > > > thanks, > > > > > > > > larry > > > > > > > > -- > > > > Larry C. Lyons > > > > ColdFusion/Web Developer > > > > Certified Advanced ColdFusion 5 Developer > > > > EBStor.com > > > > 8870 Rixlew Lane, Suite 204 > > > > Manassas, Virginia 20109-3795 > > > > tel: (703) 393-7930 > > > > fax: (703) 393-2659 > > > > Web: http://www.ebstor.com > > > > email: [EMAIL PROTECTED] > > > > Chaos, panic, and disorder - my work here is done. > > > > -- > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
