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 strongm 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: *

  1. Poseidon

    how to get sum of amount for previous 3 months (dynamically)

    hi try ist this way: select sum(currentdue) from dues where year = year(current date) and month < month(current date) martin
  2. Poseidon

    Using host variable with 'like' operator

    jay, try this: set PATTERN to &quot;NM&quot; SELECT * FROM MYTABLE WHERE COLUMN1 LIKE '%' !! :PATTERN !! '%' martin

Part and Inventory Search

Back
Top