Let's start to create the database - trail
Table - Faculty
Insert records
Select * from Faculty
Shows all records within the table.
LIKE 'V[%]' : Searches for strings starting with the "v" character.
LIKE '[_]n' : Searches for strings starting with any character, but the second character must be 'a' character.
LIKE 'ra[d]' : Searches for strings starting with "ra" but after "ra" there must be a "d" character.
NOT LIKE 'ra[d]' : Searches for strings not starting with "ra" or after "ra" there is not a "d" character in the string.
There are several patterns for searching strings.
SubashPosted Jul 29, 2016, 7:44 AM
Nice
sonia naiduPosted Apr 5, 2012, 6:44 AM
im using microsoft visual c# express and its database. through my c# program i wanted to retrieve a folder path from the database to select files.but im getting this error.please help. i have created a column 'folder_path nvarchar(50)' my folder path is : @"f:/pick_up" if i put folder path as 'comp' it reads.i guess the error has something to do with special characters @,/ and ". reply asap.thank you