---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# mssql:test\n# glaredb:skip — TODO: started raising an error on 2024-05-20; see `window.prql`\n# for more details\nfrom albums\nselect {\n    title,\n    title_and_spaces = f\"  {title}  \",\n    low = (title | text.lower),\n    up = (title | text.upper),\n    ltrimmed = (title | text.ltrim),\n    rtrimmed = (title | text.rtrim),\n    trimmed = (title | text.trim),\n    len = (title | text.length),\n    subs = (title | text.extract 2 5),\n    replace = (title | text.replace \"al\" \"PIKA\"),\n}\nsort {title}\nfilter (title | text.starts_with \"Black\") || (title | text.contains \"Sabbath\") || (title | text.ends_with \"os\")\n"
input_file: prqlc/prqlc/tests/integration/queries/text_module.prql
---
Bach: The Brandenburg Concertos,  Bach: The Brandenburg Concertos  ,bach: the brandenburg concertos,BACH: THE BRANDENBURG CONCERTOS,Bach: The Brandenburg Concertos,Bach: The Brandenburg Concertos,Bach: The Brandenburg Concertos,31,ach: ,Bach: The Brandenburg Concertos
Bach: Violin Concertos,  Bach: Violin Concertos  ,bach: violin concertos,BACH: VIOLIN CONCERTOS,Bach: Violin Concertos,Bach: Violin Concertos,Bach: Violin Concertos,22,ach: ,Bach: Violin Concertos
Bartok: Violin & Viola Concertos,  Bartok: Violin & Viola Concertos  ,bartok: violin & viola concertos,BARTOK: VIOLIN & VIOLA CONCERTOS,Bartok: Violin & Viola Concertos,Bartok: Violin & Viola Concertos,Bartok: Violin & Viola Concertos,32,artok,Bartok: Violin & Viola Concertos
Black Album,  Black Album  ,black album,BLACK ALBUM,Black Album,Black Album,Black Album,11,lack ,Black Album
Black Sabbath,  Black Sabbath  ,black sabbath,BLACK SABBATH,Black Sabbath,Black Sabbath,Black Sabbath,13,lack ,Black Sabbath
Black Sabbath Vol. 4 (Remaster),  Black Sabbath Vol. 4 (Remaster)  ,black sabbath vol. 4 (remaster),BLACK SABBATH VOL. 4 (REMASTER),Black Sabbath Vol. 4 (Remaster),Black Sabbath Vol. 4 (Remaster),Black Sabbath Vol. 4 (Remaster),31,lack ,Black Sabbath Vol. 4 (Remaster)
Da Lama Ao Caos,  Da Lama Ao Caos  ,da lama ao caos,DA LAMA AO CAOS,Da Lama Ao Caos,Da Lama Ao Caos,Da Lama Ao Caos,15,a Lam,Da Lama Ao Caos
Jorge Ben Jor 25 Anos,  Jorge Ben Jor 25 Anos  ,jorge ben jor 25 anos,JORGE BEN JOR 25 ANOS,Jorge Ben Jor 25 Anos,Jorge Ben Jor 25 Anos,Jorge Ben Jor 25 Anos,21,orge ,Jorge Ben Jor 25 Anos
Meus Momentos,  Meus Momentos  ,meus momentos,MEUS MOMENTOS,Meus Momentos,Meus Momentos,Meus Momentos,13,eus M,Meus Momentos
Mozart: Wind Concertos,  Mozart: Wind Concertos  ,mozart: wind concertos,MOZART: WIND CONCERTOS,Mozart: Wind Concertos,Mozart: Wind Concertos,Mozart: Wind Concertos,22,ozart,Mozart: Wind Concertos
Plays Metallica By Four Cellos,  Plays Metallica By Four Cellos  ,plays metallica by four cellos,PLAYS METALLICA BY FOUR CELLOS,Plays Metallica By Four Cellos,Plays Metallica By Four Cellos,Plays Metallica By Four Cellos,30,lays ,Plays MetPIKAlica By Four Cellos
Warner 25 Anos,  Warner 25 Anos  ,warner 25 anos,WARNER 25 ANOS,Warner 25 Anos,Warner 25 Anos,Warner 25 Anos,14,arner,Warner 25 Anos