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. > > -- > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
