SELECT field.value  FROM BaseObject as obj, StringProperty as field WHERE obj.name=:groupdocname and obj.className=:groupclassname and obj.id=field.id.id and (trim(both from field.value)<>'' or (trim(both from field.value) is not null and '' is null))

registerFunction( "trim", new SQLFunctionTemplate( StandardBasicTypes.STRING, "trim(?1 ?2 ?3 ?4)" ) );

	public String render(List args, SessionFactoryImplementor factory) {
		int numberOfArguments = args.size();
		if ( getAnticipatedNumberOfArguments() > 0 && numberOfArguments != getAnticipatedNumberOfArguments() ) {
			log.warn( "Function template anticipated {} arguments, but {} arguments encountered",
					getAnticipatedNumberOfArguments(), numberOfArguments );
		}
		StringBuffer buf = new StringBuffer();
		for ( int i = 0; i < chunks.length; ++i ) {
			if ( i < paramIndexes.length ) {
				final int index = paramIndexes[i] - 1;
				final Object arg =  index < numberOfArguments ? args.get( index ) : null;
				if ( arg != null ) {
					buf.append( chunks[i] ).append( arg );
				}
			}
			else {
				buf.append( chunks[i] );
			}
		}
		return buf.toString();
	}