OpenOffice.info

Code: Alles auswählen

SELECT "Name", "Vorname", "Rezept-datum", "1.", "2.", "3.", "4.", "5.", "6.", "7.", "8.", "9.", "10.", "weitere Daten, wenn mehr als 10 Behandlungen pro Verordnung" AS "11.", "12" AS "12.", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36" FROM "Tabelle16" WHERE LOWER ("Name") Like LOWER (:qName ||'%')

Code: Alles auswählen

WHERE LOWER ("Name") Like LOWER (:qName ||'%')

Code: Alles auswählen

WHERE LOWER ("Name") Like LOWER (:qName ||'%')

Code: Alles auswählen

WHERE LOWER ("Name") Like LOWER (:qName) ||'%'

Code: Alles auswählen

SELECT "Name", "Vorname", "Rezept-datum" AS "Rez.-dat.", "1.", "2.", "3.", "4.", "5.", "6.", "7.", "8.", "9.", "10.", "VO.1" AS "Verordng. 1", "VO.2" AS "Verordng. 2", "Indika-tionsschlüssel" AS "Indikationsschl.", "ICD-10-Code" AS "ICD_Code", "Erstverord-nung" AS "Erstver.", "Folge-verordnung" AS "Folgever.", "Verordnung außerhalb des Regel-falls" AS "Regelfall", "Abrechnungsmonat" FROM "Tabelle16" WHERE "Name" = :qName AND "Vorname" = :qVorname

Code: Alles auswählen

WHERE LOWER ("Name") LIKE CONCAT( LOWER (:qName),'%')

Code: Alles auswählen

SELECT "Name", "Vorname", "Rezept-datum" AS "Rez.-dat.", "1.", "2.", "3.", "4.", "5.", "6.", "7.", "8.", "9.", "10.", "VO.1" AS "Verordng. 1", "VO.2" AS "Verordng. 2", "Indika-tionsschlüssel" AS "Indikationsschl.", "ICD-10-Code" AS "ICD_Code", "Erstverord-nung" AS "Erstver.", "Folge-verordnung" AS "Folgever.", "Verordnung außerhalb des Regel-falls" AS "Regelfall", "Abrechnungsmonat" FROM "Tabelle16" WHERE LOWER ( "Name" ) LIKE CONCAT( LOWER ( :qName ), '%' ) AND LOWER ( "Vorname" ) LIKE CONCAT( LOWER ( :qVorname ), '%' )