echo "CREATE TABLE Info (" | grep -i "[ ]*CREATE[ ]*TABLE[ ]*Info[ ]*(" | wc -l --> It looks right syntactically. But since you're echo-ing just one line, there's not point in piping it to wc -l as you already know the line count is '1'.
(oh sorry i forgot to put quotes to the variable)but i meant the code wont work because of space parameter between 'info' and '(' in the variable... how to rectify that...? is there any way so that it will check whether that line is present or not in the file even thought there is variable spaces between the words in the variable?
thanks this might work i hope there is no other option to directly make them space insenstive by using some options or regular expressions (i was trying to avoid manipulating the variable content so)... thanks anyway