\$ operator?

1. Senior Member
Join Date
Dec 1969
Posts
598

## \$ operator?

I know that there is \$ operator in Foxpro. Is there \$ operator in sql and asp? <BR><BR>I want to do a sql so that it can get the records of certain status. The status can be one type or many. I hope to do it in a single sql if possible.

2. Senior Member
Join Date
Dec 1969
Posts
1,203

## RE: \$ operator?

no, but tell us a little more about what you wish to accomplish. It doesn&#039;t sound like too tough of a task.<BR><BR>And what does the \$ do in FoxPro?

3. Senior Member
Join Date
Dec 1969
Posts
598

## RE: \$ operator?

Thanks for offering to help. I have solved the problem... Through the longer way... :)<BR><BR>Sql can only check for a field equals to 1 value right or we can do like [STATUS] = &#039;01&#039; OR [STATUS] = &#039;02&#039;)? <BR><BR>With the \$ operator, we can check if the field is equal to more than 1 values without the OR.<BR><BR>Hope that is clear. :) I&#039;m very bad in explaining

4. Senior Member
Join Date
Dec 1969
Posts
7,686

## RE: \$ operator?

(T-)SQL has many options to select fields:<BR>Operators:<BR><BR>= (Equals) <BR>&#062; (Greater Than) <BR>&#060; (Less Than) <BR>&#062;= (Greater Than or Equal To) <BR>&#060;= (Less Than or Equal To)<BR>&#060;&#062; (Not Equal To) <BR>!= (Not Equal To) (not SQL-92 standard)<BR>!&#060; (Not Less Than) (not SQL-92 standard)<BR>!&#062; (Not Greater Than) (not SQL-92 standard)<BR><BR>Logical operators:<BR><BR>&#039;ALL&#039; TRUE if all of a set of comparisons are TRUE.<BR>&#039;AND&#039; TRUE if both Boolean expressions are TRUE.<BR>&#039;ANY&#039; TRUE if any one of a set of comparisons are TRUE.<BR>&#039;BETWEEN&#039; TRUE if the operand is within a range.<BR>&#039;EXISTS&#039; TRUE if a subquery contains any rows.<BR>&#039;IN&#039; TRUE if the operand is equal to one of a list of expressions.<BR>&#039;LIKE&#039; TRUE if the operand matches a pattern.<BR>&#039;NOT&#039; Reverses the value of any other Boolean operator.<BR>&#039;OR&#039; TRUE if either Boolean expression is TRUE.<BR>&#039;SOME&#039; TRUE if some of a set of comparisons are TRUE.<BR><BR>And more including bitwise and unary, just look into the Transact SQL docs.<BR><BR>Peter

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•