@PaigeMiller , please see below for the full error message. Thank you, 36 (case
_
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
37 when a. SIGHTINGS >= 0 and a. SIGHTINGS <= 49.99 then '1.0-49'
____
22
76
ERROR 22-322: Syntax error, expecting one of the following: a name, (, ',', '.', ANSIMISS, AS, CROSS, FULL, INNER, JOIN, LEFT,
NATURAL, NOMISS, RIGHT.
ERROR 76-322: Syntax error, statement will be ignored.
38 when >= 50 a.SIGHTINGS <= 99.99 then '2.50-99'
39 when >= 100 a. SIGHTINGS <= 249.99 then '3.100-249'
40 when >= 250 a.SIGHTINGS <= 499.99 then '4.250-499'
41 when >= 500 a. SIGHTINGS <=999.99 then '5.500-999'
42 when a. SIGHTINGS >= 1000 then '6.1000+'
43 else '' end) as Buckets
44
... View more