cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted Search with like

Former Member
0 Kudos

I'am tring to do a Formatted Search with this: SELECT DISTINCT T0.Code, T0.Name

FROM T0 LEFT OUTER JOIN

ORDR ON T0.Name = ORDR.U_PDischar WHERE T0.Name Like '$[ORDR.U_PDISCHAR] %%' ORDER BY T0.Name

but it not work any help... thanks

Message was edited by: Juan F Vásquez

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

This worked for me:

SELECT DISTINCT T0.Code, T0.Name

FROM T0 LEFT OUTER JOIN

ORDR ON T0.Name = ORDR.U_PDischar WHERE T0.Name

Like $[ORDR.U_PDISCHAR] + '%%' ORDER BY T0.Name

Not whit this same fields, but with others.

Hope helps,

Ibai Peñ