Why didnt' you just say that? ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Monday, August 12, 2002 8:25 AM Subject: Re: Semi OT: M$ Access Equivalent to SQL Server Substring function
> 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. > > > > > -- > > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
