In a message dated 12/14/2010 9:30:18 AM Pacific Standard Time, [email protected] writes:
> SELECT FBNK.CUSTOMER.POSITION WITH @ID LIKE '...MIAJL01A...' > > We do know that there are records that fits that condition, but the > select does not return anyhting. It is curious, because the same select, but > without the 'A' at the end, works > > SELECT FBNK.CUSTOMER.POSITION WITH @ID LIKE '...MIAJL01...' > You need to say SELECT FBNK.CUSTOMER.POSITION WITH @ID LIKE '..."MIAJL01A"...' i.e. enquote the literal to force it to understand that this is a literal string, not a pattern match. The '1A' looks like a pattern to Universe (one alphabetic) instead of the number 1 followed by the letter A. Will Johnson -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
