Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: stepen123
  • Content: Threads
  • Order by date
  1. stepen123

    Searching non-adjacent Varbinaries in another Varbinary

    I need to search between 1 and 5 NON-ADJACENT occurrences of a Varbinary field in another Varbinary field. For example to find in which record are A,B,C and D, querying a field with stuffAstuffstuffBstuffCstuffDstuffstuff. Here is the real picture: There is a Table1 (no more than 300,000...
  2. stepen123

    BITSET() and BITTEST () with Varbinary(2)

    Hello, I have a field pos_bin, which is Varbinary(2). The following command: REPLACE pos_bin WITH BITSET(pos_bin,1) produces 0200 in the field and REPLACE pos_bin WITH BITSET(pos_bin,8) gives 0201. How can I revert the result, so that when I set bit #0 I get 0001 and when I set...
  3. stepen123

    Right to left sort/index order

    I have to arrange words in reverse order (right to left) to explore the suffixes. Here is an example: http://tinyurl.com/4tvugvr. The Help says 'RightToLeft [property] is disregarded unless you are running a Middle Eastern version of Microsoft Windows.' Is there a way to do it in VFP or Excel...
  4. stepen123

    Searching with keywords in VFP

    Is it possible to search with keywords in any order? For example a field contains the keywords 'journey earth centre', another record has a field with 'centre journey earth'. Is it possible to find both records by searching for 'earth journey centre'? If yes, how should the query be made? What...

Part and Inventory Search

Back
Top