Re: [SQL] Like phrase

2003-09-03 Thread Tomasz Myrta
Hello, I've got a question about "LIKE" phrase. I have such a phrase: LIKE UPPER(Key_Zawod) And I want to write after Key_Zawod % but it doesn't work. Is there any special way to code this phrase? like upper(key_zawod) || '%' Regards, Tomasz Myrta ---(end of broadcast)-

[SQL] Like phrase

2003-09-03 Thread Michał Wróblewski (Muerte)
Hello, I've got a question about "LIKE" phrase. I have such a phrase: LIKE UPPER(Key_Zawod) And I want to write after Key_Zawod % but it doesn't work. Is there any special way to code this phrase? -- greetings Michał Wróblewski #GG: 111769 #ICQ: 113904213 Administrator Sieci SSK Ligota: ww