Note To Myself: MS SQL Server Wildcards And Importing From A Textfile

Wildcards on MS SQL % (percent) sign for multiple characters and _ (underscore) for a single character.
If you want to import from a textfile you can use the BULK INSERT command, but the textfile has to be on the local disk.