# Re: Store procedure 问题

Posted by Nicky on December 23, 1998 at 13:40:20:

In Reply to: Store procedure 问题 posted by L.A. on December 22, 1998 at 23:12:05:

: 本人想在Store procedure 执行以下程式出现错误.

: create procedure .....

: @cString char(4)

: Select field1, field2 from table1 where field1 like @cstring & "%"

: 本人不知道如何下后半句指令, 本想将field1 包括 cstring 条件的记录显示出来.

: 请多多指教.

试试
"Select field1,field2 from table1 where field1 like '*cstring*';"

Follow Ups: