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. > > > -- > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
