Autocomplete by a middle word ?

can Sql assistant show autocomplete( ctrl+space) by a part of the word and not just by the BEGINNING OF THE WORD ?

I'm not sure I understand your question. Can you offer a specific example?

For example i have a column name "MyTotalExpense"

The sql assistant window will navigate to this field only if i press "m..y..t.."

which means it searches at the beginning of the word

My question is : can i configure it to show me that column even if i press "e..x..p..e.." ( middle of the word and not JUST begining of the word....)

Yes. Change SA-Options > DB Options > SQL Assistance (chosen DBMS) > Name Matching Method accordingly. Set it to "Name Contains Key String" if you want to filter on the word you type anywhere in the fields. Or set it "Name Contains Characters from Key String" for more flexibility. This one requires some practice but can drastically reduce the number of keypresses required to find what you need.

totaly agree. it does remove tryings......

however i dont understand the difference between the 2 other oprions.

I got it. thank you.

	rnan wrote:
	totaly agree. it does remove tryings...... however i dont understand the difference between the 2 other oprions.

"Name Contains Key String" requires the characters you type to be a filter word, that is, they need to be next to each other and in the given order.

"Name Contains Characters from Key String" only enforces their order, other than that they can be anywhere in the field name.