Hi, there is no "==" in SQL. If you want an exact compare, use "=". If you want to check something like "does string a begin with 'abc'" you have to compare with
" a LIKE 'abc%' " where % is a wildcard for no, one or many letters. Florian K�rner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]Im Auftrag von Francisco > Morosini > Gesendet: Donnerstag, 12. Dezember 2002 22:46 > An: [EMAIL PROTECTED] > Betreff: comparing strings for sql select > > > in Visual Foxpro i can use = for compare two strings equal like: > > 'a' = 'ab' is true because the minor string is equal to the same part of > size of the bigger string 'a' = 'a' > but when i need use exact comparing string i use: > > 'a' == 'ab' is false because not match exactly. > > how i can do this behavior in SAP DB? > > Regards > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.427 / Virus Database: 240 - Release Date: 06/12/2002 > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
