This may seem like an obvious thing, but I want to know know if there are wildcards in C# for matching strings. I want to write a program so that users can search for something based on the date value in the database. What I have so far works as long as the whole date is entered, but entering half a date causes a parsing error I'm using this code now
" ... where Date like " DateTime.Parse(textbox.text.trim()) " + %;"
I want to see if there is an way to see what the user input (only the year, or month and year without day, or for it not to crash if only half the year is entered)
A solution that involves doing this in SQL itself doesn't matter