Results 1 to 2 of 2

Thread: help

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: help

    Does anyone see anything wrong with this statement

    Code:
    CREATE FUNCTION "All Bally Games" () 
    	RETURNS TABLE 
    	AS RETURN (SELECT TOP 100 PERCENT "Master List"."Tribal No", "Master List"."Stand No", 
    	"Master List"."Serial No", "Master List".Manufacturers, "Master List".Description, "Master 
    	List".Denomination, "Master List".Class, "Bally Main Eprom"."ID Number A", "Bally Main 
    	Eprom"."ID Number B"
    	FROM "Master List" INNER JOIN "Bally Main Eprom" ON ("Master List"."Tribal No" = "Bally 
    	Main Eprom"."Tribal No")
    	WHERE ((("Master List".Manufacturers) Like '5'))

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Unless you include a percent sign (%), the LIKE clause could just as well be an equal sign. I would much prefer the use of brackets [] over the use of quotes "" if that is acceptable.

    That's all that jumps right out at me.

    -PatP

Posting Permissions

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