TSF.UmlToolingFramework.Wrappers.EA.Model.replaceSQLWildCards C# (CSharp) Method

replaceSQLWildCards() private method

replace the wildcards in the given sql query string to match either MSAccess or ANSI syntax
private replaceSQLWildCards ( string sqlQuery ) : string
sqlQuery string the sql string to edit
return string
        private string replaceSQLWildCards(string sqlQuery)
        {
            bool msAccess = this.repositoryType == RepositoryType.ADOJET;
            int beginLike = sqlQuery.IndexOf("like",StringComparison.InvariantCultureIgnoreCase);
            if (beginLike > 1 )
            {
            int beginString = sqlQuery.IndexOf("'",beginLike + "like".Length);
            if (beginString > 0)
            {
                int endString = sqlQuery.IndexOf("'",beginString +1);
                if (endString > beginString)
                {
                    string originalLikeString = sqlQuery.Substring(beginString +1,endString - beginString );
                    string likeString = originalLikeString;
                    if (msAccess)
                    {
                        likeString = likeString.Replace('%','*');
                        likeString = likeString.Replace('_','?');
                        likeString = likeString.Replace('^','!');
                    }
                    else
                    {
                        likeString = likeString.Replace('*','%');
                        likeString = likeString.Replace('?','_');
                        likeString = likeString.Replace('#','_');
                        likeString = likeString.Replace('^','!');
                    }
                    string next = string.Empty;
                    if (endString < sqlQuery.Length)
                    {
                        next = replaceSQLWildCards(sqlQuery.Substring(endString +1));
                    }
                    sqlQuery = sqlQuery.Substring(0,beginString+1) + likeString + next;

                }
            }
            }
            return sqlQuery;
        }