From 1a4bafb95bf16ef06c412cbc609c474941ae9924 Mon Sep 17 00:00:00 2001
From: "Kevin M. Rosenberg" <kevin@rosenberg.net>
Date: Sat, 2 Aug 2003 07:03:00 +0000
Subject: [PATCH] r5436: *** empty log message ***

---
 package.lisp     |  5 ++++-
 sql-classes.lisp | 20 +++++++++++++++++++-
 2 files changed, 23 insertions(+), 2 deletions(-)

diff --git a/package.lisp b/package.lisp
index 259c5f4..963b298 100644
--- a/package.lisp
+++ b/package.lisp
@@ -7,7 +7,7 @@
 ;;;; Programmer:    Kevin M. Rosenberg
 ;;;; Date Started:  Apr 2000
 ;;;;
-;;;; $Id: package.lisp,v 1.29 2003/07/21 09:46:22 kevin Exp $
+;;;; $Id: package.lisp,v 1.30 2003/08/02 07:03:00 kevin Exp $
 ;;;;
 ;;;; This file, part of UMLisp, is
 ;;;;    Copyright (c) 2000-2003 by Kevin M. Rosenberg, M.D.
@@ -125,6 +125,9 @@
    #:find-ucon-tui
    #:find-ucon-word
    #:find-ucon-normalized-word
+   #:find-cui-normalized-word
+   #:find-lui-normalized-word
+   #:find-sui-normalized-word
    #:find-ustr-word
    #:find-ustr-normalized-word
    #:find-uterm-multiword
diff --git a/sql-classes.lisp b/sql-classes.lisp
index 34cbd2a..99634ca 100644
--- a/sql-classes.lisp
+++ b/sql-classes.lisp
@@ -7,7 +7,7 @@
 ;;;; Author:        Kevin M. Rosenberg
 ;;;; Date Started:  Apr 2000
 ;;;;
-;;;; $Id: sql-classes.lisp,v 1.90 2003/07/21 11:22:51 kevin Exp $
+;;;; $Id: sql-classes.lisp,v 1.91 2003/08/02 07:03:00 kevin Exp $
 ;;;;
 ;;;; This file, part of UMLisp, is
 ;;;;    Copyright (c) 2000-2003 by Kevin M. Rosenberg, M.D.
@@ -553,6 +553,24 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS"
 				      :lrl 'klrl :order '(cui asc))
     (find-ucon-cui cui :srl srl)))
 
+(defun find-cui-normalized-word (word &key (srl *current-srl*) (like nil))
+  "Return list of cui that match word, optionally use SQL's LIKE syntax"
+  (collect-umlisp-query-eval ('mrxnw_eng '(cui) srl 'nwd word :like like :distinct t
+					 :lrl 'klrl :order '(cui asc))
+			     cui))
+
+(defun find-lui-normalized-word (word &key (srl *current-srl*) (like nil))
+  "Return list of cui that match word, optionally use SQL's LIKE syntax"
+  (collect-umlisp-query-eval ('mrxnw_eng '(lui) srl 'nwd word :like like :distinct t
+					 :lrl 'klrl :order '(cui asc))
+			     lui))
+
+(defun find-sui-normalized-word (word &key (srl *current-srl*) (like nil))
+  "Return list of cui that match word, optionally use SQL's LIKE syntax"
+  (collect-umlisp-query-eval ('mrxnw_eng '(sui) srl 'nwd word :like like :distinct t
+					 :lrl 'klrl :order '(cui asc))
+			     sui))
+
 (defun find-ustr-word (word &key (srl *current-srl*))
   "Return list of ustrs that match word"
   (collect-umlisp-query (mrxw_eng (cui sui) srl wd word :lrl klrl
-- 
2.34.1