What does %=% mean?

[jjac69]

Found %=% in a parameter passed to a sql statement function. Don't recognize it and cannot find a reference

 

[Dan Freeman]

% is the SQL wildcard character. That's probably searching for a string with one or more characters on each side of an =.

 

[JRB-Bldr]

"Found %=% in a parameter passed to a sql statement function"

Remember that when you 'pass a SQL statement' to a SQL Server you are using SQL Server syntax, not necessarily the same as used by VFP SQL.

Dan is right above when he indicates that the %=% is SQL Server syntax and used within character data. It is not VFP syntax.

In other situations is would be comparable to
*=*
meaning:
<anything>=<anything>

Good Luck,
JRB-Bldr

 

[Mike Lewis]

Dan is right above when he indicates that the %=% is SQL Server syntax and used within character data. It is not VFP syntax.[/qupte

Not so. The syntax has nothing to do with SQL Server. It is ANSI standard SQL, and works with all SQL-92 compliant systems, including VFP.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

It should be used in something like SELECT ... FROM ... WHERE ... LIKE '%=%' and will find records having a '=' somewhere in a field.

This works in foxpro, too: Eg Select * From Home()+"\FFC\_BASE.VCX" where Properties Like '%=%'
displays all records of that class library having a property value assignment in them.

There is alsow the LIKE() function in foxpro, which takes * as joker character instead of %, which may be, why jrbbldr thought it's not VFP syntax.

If it's not used in LIKE, then show us more, eg the stored procedure and how that parameter is used, but % being used in Like in some SQL is the most probable.

Bye, Olaf.

 

[Mike Lewis]

By the way, when I said it has got nothing to do with SQL Server, I meant that it is not specific to SQL Server. The use of the two wildcards (percent and underline) is defined by the ANSI standard.

And, as I said before, it definitely works in FoxPro.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy