Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Can I use the $ operator ?

2 posts in FoxPro Last posting was on 2007-01-16 15:25:05.0Z
Hugo Glez Posted on 2007-01-13 06:15:19.0Z
From: "Hugo Glez" <gomh7172@prodigy.net.mx>
Newsgroups: Advantage.FoxPro
Subject: Can I use the $ operator ?
Date: Sat, 13 Jan 2007 00:15:19 -0600
Lines: 18
Organization: 3GM
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 189.165.19.160
Message-ID: <45a877f1@solutions.advantagedatabase.com>
X-Trace: 12 Jan 2007 23:10:57 -0700, 189.165.19.160
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.165.19.160
Xref: solutions.advantagedatabase.com Advantage.FoxPro:221
Article PK: 1109575

What function or operator can I use for:

cSearchFor $ cSearchInReturns True if a character expression is contained in
another character expression; otherwise, returns False.

For example:

'gonzalez' $ 'hugo gonzalez macias' ==> return TRUE

'gonza' $ 'hugo gonzalez macias' ==> return TRUE

'gonzaga' $ 'hugo gonzalez macias' ==> return FALSE

In VFP I use the operator '$'

Thank you


Jeremy Mullin Posted on 2007-01-16 15:25:05.0Z
Date: Tue, 16 Jan 2007 15:25:05 +0000 (UTC)
Message-ID: <886edc152116a8c9075ef61a759f@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Can I use the $ operator ?
Newsgroups: Advantage.FoxPro
References: <45a877f1@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 928.2
NNTP-Posting-Host: 10.24.38.110
X-Trace: 16 Jan 2007 08:20:46 -0700, 10.24.38.110
Lines: 24
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.110
Xref: solutions.advantagedatabase.com Advantage.FoxPro:222
Article PK: 1109576

This post was answered in the sql newsgroup crosspost.

J.D. Mullin
Advantage R&D

> What function or operator can I use for:
>
> cSearchFor $ cSearchInReturns True if a character expression is
> contained in another character expression; otherwise, returns False.
>
> For example:
>
> 'gonzalez' $ 'hugo gonzalez macias' ==> return TRUE
>
> 'gonza' $ 'hugo gonzalez macias' ==> return TRUE
>
> 'gonzaga' $ 'hugo gonzalez macias' ==> return FALSE
>
> In VFP I use the operator '$'
>
> Thank you
>